Data Transformation Builder Select case statement

Question

Question

Tom McDevitt · Jun 6, 2017

Using the Data Transformation Builder I see the action if but in my scenario a case statement would be better. Is there anyway to do a case statement? This way I dont need to build a long if else logic.

Discussion (3)1

Log in or sign up to continue

Marc Mundt · Jun 6, 2017

Yes, you just need to wrap them in parentheses and use "||" for "or":

if ((ReceivingFacility="A") || (ReceivingFacility="B") || (ReceivingFacility="C")) {

Or look at using other functions like $LISTFIND or the "[" (contains) operator:

if ($LISTFIND($LISTBUILD("A","B","C"), ReceivingFacility) {

0 0

score 0 · Answer 1 · 2017-06-06T12:47:07-04:00

If you just need to get an output value based on different input values, a lookup table would be the best option.

If you actually need to execute completely different logic depending on the input value, then you can consider using code actions to add a series of ElseIfs, which are much easier to read than deeply nested if blocks.

score 0 · Answer 2 · 2017-06-06T13:50:52-04:00

Thanks, Are you able to have multiple conditions?

if ReceivingFacility="A" or ReceivingFacility="B" or ReceivingFacility="C" {