Multiple column data conditions

Question

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

Output data.PNG

yeruvab · Answer

Here is the snapshot of output column how it should be, not sure how to use the multi row or multi formula tools.

Output data.PNG

yeruvab · Answer

Sorry about that, Yes I have multiple data checks on multiple columns and output  into new column based on the conditions, I'm using the below IF function but this is not giving the desired output, I have attached input and output data for reference, edited the question above.

Question.yxmd

Watermark · Answer

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?