ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now
1 Day Left! - The Alteryx Community will be temporarily unavailable for a few hours due to implementation of the new SSO experience starting tomorrow at 5pm MDT. Please plan accordingly. For more information, read the blog.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

How to remove all null values in rows?

CoreyS
8 - Asteroid

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:

remove_null_values.PNG

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Thanks for your support in advance!

 

Respectfully,

Corey

Qiu
17 - Castor

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

Capture1a.PNGCapture1b.PNG

CoreyS
8 - Asteroid

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

 

Respectfully,

Corey

Qiu
17 - Castor

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

Labels