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

@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.

New Workflow1.yxmd