Data Validation

[vijaylnyadav]

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.

[atcodedog05 · Accepted solution]

Hi @vijaylnyadav 

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 🙂

[aesanchez]

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!