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
Solved! Go to 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
Glad to help and thank you for the accept mark.