Using the IF and IN in the same formula

Hi There,

I have a formula:

IF [Goal] IN("K-4", "R-2", "M-3", "Z-1") THEN "Yes" ELSE "N/A" ENDIF

There is a item in my data set that has a "K-4" and thus should be "Yes" but alteryx is not recognizing this.

I have cleansed the data of white spaces.

Can you please let me know what you think.

Thank you

Expression

Accepted answers

I think the problem is not in the data but rather in your column name.

Your column reads as "Goal " i.e. with spaces

Either manually correct by removing all the spaces before and after, so that you have "Goal" OR

If this is coming in from another source, then Alteryx it using Dynamic Rename Tool configured per below.

The formula should have worked. Could you provide us some sample data for us to look at? Just a couple of values from the Goal column should do.

Try this instead (nest the Goal in a TRIM).

IF TRIM([Goal]) IN("K-4", "R-2", "M-3", "Z-1") THEN "Yes" ELSE "N/A" ENDIF

I hope this helps!

Hi There,

Please see attached

i tried this but it didn't work - thank yo for trying.