If else condition

[carmenwu1]

Hi all,

I have a question about how to incorporate an if-else statement in the Alteryx workflow.

Basically, I want do something like "if the absolute value of USD under USA is greater than that under UK, do XYZ, else do XYZ". Any advice? Thank you so much!

Location    USD

USA          9,000,000

UK             -1,234,567

[CokeLuke]

How about something like this by adjusting the input data?

Text input:

Formula:

Browse:

[AbhilashR]

Hi @carmenwu1, you could use a multi-row formula to setup an IF Else statement across rows. Something like the screenshot below:

IF ABS([USD])>ABS([Row+1:USD])
   THEN 'XYZ'
ELSE 'ABC'
ENDIF