IF THEN check for Null value

[sucansa]

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?

[Thableaus]

Hi @sucansa 

Instead of isnull, try Null()

Cheers,

[NickSm · Accepted 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.

[CharlieS]

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.