If else condition
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
carmenwu1
5 - Atom
‎03-29-2021
03:38 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Labels:
- Labels:
- Workflow
2 REPLIES 2
CokeLuke
8 - Asteroid
‎03-29-2021
04:06 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
How about something like this by adjusting the input data?
Text input:
Formula:
Browse:
AbhilashR
15 - Aurora
‎03-29-2021
08:43 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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