Encode Operation
Last updated
⌘Ctrlk
Buckets date values into conditional partitions and encodes each partition with a specified replacement value.
The Encode operation evaluates each row using a set of conditional rules (When/Then pairs). The first matching rule determines the output value for that row.
When — Column
The source column to evaluate (pre-filled with the current column).
When — Condition
The comparison operator (e.g., equals, greater than, less than).
When — Value
The value to compare against.
Then — Type
The type of the replacement value (Constant or Column).
Then — Value
The value to write when the condition matches.
+ (Add rule)
Adds another When/Then condition pair.
Create New Column
When enabled, writes the encoded result to a new column.
Column Name
The name of the new column.
Rules are evaluated in order. Rows that do not match any condition retain their original value.
Last updated