Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Hide rows with no value

nphuong84
7 - Meteor

Hi All,

I have the table like this, I want to hide the lines which all cells have no value (in this case the Row C, H & L)

 

Name1.002.003.004.005.006.007.008.009.0010.00
A 1,190.520.5017.50-153.7829.2249.50   
B 574.48 171.00 7,640.78    
C          
D 1.63        
E 309.27 10.00 1,242.00    
F   8.90 -2,019.54    
G 0.82 87.50 30,314.50    
H          
I9.134,719.48162.00390.2013,600.0039,590.0010,619.00   
L          
M  112.00112.005,605.005,605.004,248.00   

 

Can someone advise me how to do this in Alteryx?

 

Thank you much

8 REPLIES 8
Jean-Balteryx
16 - Nebula
16 - Nebula

Hi @nphuong84 ,

 

I attached the workflow containing the solution I came up with.

 

Basically, I transpose the data to get one value per cell for each "Name" and count the number of non-null values. Then I filter out "Name" values having 0 non-null values (so all values are null) and join back the original data.

 

Don't hesitate if you have any questions or need more details.

 

Have a great day !

 

Kind regards,

 

Jean-Baptiste

BrandonB
Alteryx
Alteryx

Some creative users have made macros that do exactly this with even a bit more flexibility:

 

https://gallery.alteryx.com/#!app/Remove-Nulls/5717e389aa690a170c480548

 

https://gallery.alteryx.com/#!app/Drop-Those-Nulls/5c86bf228a93370a808070a9

 

This one even lets you set a threshold! https://gallery.alteryx.com/#!app/Drop-on-NULL/5ac9d49e8a933718049b6544

 

 

 

nphuong84
7 - Meteor

Hi Jean,

 

Thanks for your advice, when the blank cells have value=0, the workflow does not work. Do you have any solution for this.

 

Thanks

Phuong

nphuong84
7 - Meteor

Hi Brandon,

 

Thanks for your reply. I'm new to Alteryx. Maybe macro is a little complicated with me now, but I will try to learn how to use it.

 

Thanks

Phuong

Jean-Balteryx
16 - Nebula
16 - Nebula

Hi @nphuong84 ,

 

I modified the workflow so it replaces the 0 by null.

 

Don't hesitate if you have questions or need more details.

 

Have a great day !

 

Jean-Baptiste

 

Jean-Balteryx
16 - Nebula
16 - Nebula

Hi @nphuong84 ,

 

Did you solve your problem ?

 

Kind regards,

 

Jean-Baptiste

nphuong84
7 - Meteor

Hi Jean,

 

It worked, even though my raw data have more than 5000 rows.

 

Thank you so much.

Jean-Balteryx
16 - Nebula
16 - Nebula

My pleasure @nphuong84.

 

Have a great day !

 

Kind regards,

 

Jean-Baptiste

Labels