Hello, I'm writing an IF formula, which would also include AND - if column A=X and column B=Y, then..., how could I do this in Alteryx? Thanks!
Hi @insomned,
I think you need to write something like IF [Column A] = [Column x] AND [Column B] = [Column Y] Then 1 ELSE 0 ENDIF
In [] you need to have proper column names.
Hi @insomned
Just another way the question could be looked at say "X" and "Y" are strings and not columns. Formula would be
IF [Column A] = "X" AND [Column B] = "Y"
Then 1 ELSE 0 ENDIF
These resources might be helpful
https://community.alteryx.com/t5/Interactive-Lessons/Writing-Conditional-Statements/ta-p/98910
Hope this helps : )
User | Count |
---|---|
19 | |
14 | |
13 | |
9 | |
8 |