Generates the Unicode character corresponding to an inputted Integer value. 

Unicode  is a digital standard for the consistent encoding of the world's writing systems, so that representation of character sets is consistent around the world. 

Column reference example:

derive type:single value:CHAR(MyCharIndex)

Output: The Unicode value for the number in the MyCharIndex column is written to the new column. 

String literal example:

derive type:single value:CHAR(65)

Output: The string A is written to the new column.

derive type:single value:CHAR(index_value)

ArgumentRequired?Data TypeDescription
index_valueYinteger (positive)Unicode index value of the character


Unicode index value of the character to generate or match.


Required?Data TypeExample Value
YesInteger (non-negative)65

Example - char and unicode functions