Multiple fields within "Then" Statement

[Rob83]

Hi All,

This is my case, I have an IF statement that depends on one field like:

IF a = b then

ENDIF

I need to understand how to include multiple fields being affected by the IF when True or false happens, like:

IF a = b then

 Z = 1;

 Y = 2;

 W = 3;

ELSE

 Z = 8;

 Y = 9;

 W = -1;

ENDIF

Please take the numbers assignments as an example only. In the real scenario those values would be some strings.

thank you

[messi007 · Accepted solution]

@Rob83,

I think the if statement is a good tool for this case.

I developed a simple a workflow that do this 🙂

Hope this helps,

Regards,

[AngelosPachis · Accepted solution]

Hi @Rob83 ,

Assuming your input looks something like this

and you want to apply a different condition to the records that are equal to "b", then you can split the data into two streams and then apply different formulas to each stream, before bringing everything back together

Hope that helps, let me know if that worked for you.

Regards,

Angelos