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
