The Summer Cup has officially kicked off! Get ready to learn, connect, and compete! Complete Community engagement tasks to earn points and unlock exclusive Summer Cup badges for your profile. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Case when concept in Alteryx

John_Abraham
6 - Meteoroid

I have one input file where state code is a field, and I need to check this field to do specific calculations for each state. What is the best way to do a Case when concept check in Alteryx ? In the below example, one option is to do multiple Filter tools (5 in this case) and check for true/false and proceed with the next step. Though this would work, it makes the flow cumbersome, what if there are 20 cases to check ?? Is there a better way to do it ?? 

 

Case

when ST_CD = 'IL' do IL_Process

when ST_CD = 'MT' do MT_Process

when ST_CD = 'NM' do NM_Process

when ST_CD = 'OK' do OK_Process

when ST_CD = 'TX' do TX_Process

when other do nothing

end case

 

Thanks in advance

1 REPLY 1
atcodedog05
22 - Nova
22 - Nova
Labels
Top Solution Authors