Multiple IF condition

[ashriva2]

Hi,

I am new  to alteryx and was looking for solution for below conditions:

• If the Tran code is INT, comment “Issue: Please reverse and rebook as DIVD
• If Tran code is INT+, comment “Issue: please reverse and rebook as DIVD+
• If Tran code is INT-, comment “Issue: please reverse and rebook as DIVD-
• If Tran code is RINT or RINT- comment “No issue: valid reversal”.

[FinnCharlton · Accepted solution]

Hi @ashriva2 ,

When you say 'comment', what do you mean? Do you mean adding a new column to the data, or sending a message to the workflow log? 

To add a new column, use this formula:

If you want to write to the workflow log you can use the message tool, let us know

[ashriva2]

Hi 

Thanks for your response, yes that is sending message to workflow so my input file is .xlsx. I have tried the above but I am getting result only for first condition i.e. If [Trans code] = 'INT' then "Issue: Please reverse and rebook as DIVD"

[FinnCharlton]

Like this?

[ashriva2]

So, I am attaching input file which has tran code and in col. Prep1 I require result.

[ashriva2]

It is working now, Thanks