IF THEN check for Null value

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?

Datasets

Salesforce

Accepted answers

NickSm

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.

CheckIfNull.yxmd

All comments

Thableaus

Hi @sucansa

Instead of isnull, try Null()

Cheers,

NickSm

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.

CheckIfNull.yxmd

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703