topic Re: If then statement issue in Alteryx Designer Desktop Discussions

If then statement issue

garretwalters12 — Wed, 05 Dec 2018 13:35:22 GMT

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

DavidP — Wed, 05 Dec 2018 13:39:35 GMT

Change you if statement to this:

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

Kenda — Wed, 05 Dec 2018 13:40:05 GMT

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!