Hello Alteryx community!
I have a scenario where I have to check all the conditions in multiple columns and add value based on those columns data, if then else statement is checking first condition and if its true its not going to check the next condition. Below is the formula I used. Attached the end result in the output column. Appreciate any light on this question please. Thanks!
if isnull([UM]) and not isnull([PA]) then "(" + [PA] + " " +"PA" + ")" elseif
isnull( [UM]) and not isnull([ST]) then "(" + [ST] + " " +"ST" + ")" elseif
isnull( [UM]) and not isnull([QL]) then "(" + [QL] + " " +"QL" + ")" elseif
NOT IsNull([PA]) then "("+ [PA] + " " + Substring([UM],1) elseif
NOT IsNull([ST]) then "("+ [ST] + " " + Substring([UM],1) elseif
NOT IsNull([QL]) then "("+ [QL] + " " + Substring([UM],1) else [UM]
endif
Your attachment didn't have anything in it except 2 input tools, and those both referenced spreadsheets you didn't include with the process file. Also your question isn't quite clear. Are you having trouble with an If/Then/Elseif statement?