How to remove all null values in rows?

[CoreyS]

Hello my fellow Alteryx Community,

I need your help.

In the workflow below, I'm attempting to remove all rows with null values in the column(s) [Primary ICD Code] and [Primary ICD Code Description]. However, when I used the DATA CLEANSING tool w/selected fields to cleanse, there was no change (i.e. it did not remove the rows). 

Am I doing something wrong here?

Workflow:

Thanks for your support in advance!

Respectfully,

Corey

[Qiu · Accepted solution]

@CoreyS 
I think the Cleansing Tool only removes the rows that all columns are null. 
So for case any value is null in the target columns then remove, we can do a  Transpose for those columns then filter out.

[CoreyS]

@Qiu - Thanks for the support! Your solution was exactly what I was looking for.

Respectfully,

Corey

[Qiu]

@CoreyS 
Glad to help and thank you for the accept mark.