Version: v2.4
CaseWhen
Sets values based on conditions
Type
transform
Fields
Name | Title | Description |
---|---|---|
outputCol | Output Column Name | output column name |
whenConditions | When Condition | When Condition |
values | Value | Value when this condition is true |
finallyElse | Else | else |
Examples
Input
txid | itemid | date | pyid | amount |
---|---|---|---|---|
1001 | 0001 | 2019-09-20 | 01 | 100 |
1002 | 0001 | 2019-09-20 | 02 | 100 |
Parameters
When Condition | Value |
---|---|
amount >= 100.0 and amount < 200.0 | "high_value" |
amount >=200.0 | "very_high_value" |
Name | Value |
---|---|
Output Column Name | transaction_type |
Else | "low-value" |
Output
txid | itemid | date | pyid | amount | transaction_type |
---|---|---|---|---|---|
1001 | 0001 | 2019-09-20 | 01 | 100 | high_value |
1002 | 0001 | 2019-09-20 | 02 | 100 | high_value |