Hi,
With the help of which tool we can write our if else or conditional statements for excel data validation according to the business condition defined.
Solved! Go to Solution.
You answer would be formula tool.
Here are some resources
https://community.alteryx.com/t5/Interactive-Lessons/Writing-Conditional-Statements/ta-p/98910
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Formula/ta-p/32675
https://help.alteryx.com/current/designer/formula-tool
addtionally you can use IIF alteryx formula which is similar to excel IF
Hope this helps 🙂
Hi vijaylnyadav
There are simple solutions, and more advanced solutions.
The first option is the Formula tool. Here is the help page
https://help.alteryx.com/current/designer/formula-tool
If the IF statement will be used for segregating data, the Filter tool can also help. It can be used with a simple built-in input template or receive formulas similar to the Formula tool.
https://help.alteryx.com/current/designer/filter-tool
For more advanced IF statements, you may refer to the...
... Multi-Field Formula tool https://help.alteryx.com/current/designer/multi-field-formula-tool
... Multi-Row Formula tool https://help.alteryx.com/current/designer/multi-row-formula-tool
Let me know if you have further questions!