Column A must be non null if Column B is Non null: Best way in Alteryx

[DtaViz]

Hi

I have a requirement to do validation checks for many columns and even for some columns I need to do the following checks few times with different column. The check I need to do is,

Column A must be present if Column B is present. In some cases I need to have this with many other checks like Column C have values more than 1000 etc

Eg:- If Income is over 10000, then IsTaxPaid column must be prese

Any suggestion for achieving this easily

[Ladarthure · Accepted solution]

hi @DtaViz,

you could use a formula and then a filter or directly filter with a formula like this one :

!isnull([clumn_A]) and !isnull([Column_B]) 

and you can add as many criteria as you need, tell me if it helped or you want me to explain more!