ENCODE

Returns integers for each unique string value in a referenced column.

ENCODE(column)

Returns a column with numbers assigned to each unique value of the referenced column. Used for columns with categorical data that need to be converted to numbers.

Arguments

Argument	Description
column	String column with categorical values

Output

Column of integers corresponding to the unique values in column.

Example