If then statement issue

[garretwalters12]

Why when I use the following if then statement, I am receiving a "0" instead of "NY" when true?

 

[DavidP]

Change you if statement to this:

if Contains([Item-Txt1],'NYC' then 'NY' else {Item-Txt2] endif

[Kenda · Accepted solution]

Hi @garretwalters12

Try taking out the [Item-Txt2]= between your then and 'NY' so that your formula just reads

if contains([Item-Txt1], 'NYC') then 'NY' else [Item-Txt2] endif

In Alteryx, you are specifying what column to change with the drop down at the top so you don't have to do it in your expression.

Hope this helps!