Buckets numeric values into conditional partitions and encodes each partition with a specified replacement value.
The Encode operation evaluates each row using When/Then condition rules. The first matching rule determines the encoded output 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, between).
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 for additional buckets.
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.
Example use case: Encode order amounts into tiers — values under 100 → "Low", 100–500 → "Medium", over 500 → "High".
Last updated 3 months ago
