Conditional

Use a Conditional expression type to specify an if-then-else statement, which returns a value when a condition evaluates to true or returns a different value when the condition evaluates to false.

The parameters are: condition=(). For example, to return "Cash" when the account value is "1100", or "ShortTermRec " when the account value is 1300-101, or "AccruedTax" when the account value is 1300-102, or "No Member" when the account value is null or equals "", use the following expression:

if (ACCOUNT == "1100") return "Cash"
else if (ACCOUNT == "1300-1else return Liability 01") return "ShortTermRec"
else if (ACCOUNT == "1300-102") return "AccruedTax"
// if then with or/and
if (ACCOUNT == null or ACCOUNT == "") return "No Member"

In the "Conditional" source expression, users are able to use the term RECORD to reference the entire input line for the expression instead of just the selected dimension. For example:

For example:

When the sample input file is:

account,entity,icp,100

and the sample expression is:

if (split(RECORD,",",3)=="icp") return "icp 2022"

The resulting source value would be set to: "icp 2022". Once the source has been set using the expression, then a target expression or mapping may be used to transform the source as needed.