Skip to main content
info
This documentation is for version v2.4 of the product.
For the latest version(v2.7) documentation click here
Version: v2.4 print this page

CaseWhen

Sets values based on conditions

Type

transform

Fields

NameTitleDescription
outputColOutput Column Nameoutput column name
whenConditionsWhen ConditionWhen Condition
valuesValueValue when this condition is true
finallyElseElseelse

Examples

Input

txiditemiddatepyidamount
100100012019-09-2001100
100200012019-09-2002100

Parameters

When ConditionValue
amount >= 100.0 and amount < 200.0"high_value"
amount >=200.0"very_high_value"
NameValue
Output Column Nametransaction_type
Else"low-value"

Output

txiditemiddatepyidamounttransaction_type
100100012019-09-2001100high_value
100200012019-09-2002100high_value