Hi All,
I have a usecase to check if Column A has Account number which is a string datatype then Column B should not be Null.. I am confused on how to achieve this. I tried using isnull in if then, but not sure how to achieve this.. Can someone help?
Solved! Go to Solution.
Hey @sucansa
If I'm understanding correctly, sounds like you may be on the right track with using a formula and an If / IsNull.
Could also just add this expression into the Filter tool itself and skip the formula.
Attaching a sample that may help.
I think the !isnull( function ("is not null") would be helpful here. The condition you'd like to test for is then:
IsString([Column A]) AND !isnull([Column B])
How you work that into an IF statement will depend on how you're using this test condition.