Question
Tom McDevitt · Jun 6, 2017

Data Transformation Builder Select case statement

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.

 

00
0 3 207 3

Replies

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.