Hide rows with no value

[nphuong84]

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)

Name	1.00	2.00	3.00	4.00	5.00	6.00	7.00	8.00	9.00	10.00
A		1,190.52	0.50	17.50	-153.78	29.22	49.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
I	9.13	4,719.48	162.00	390.20	13,600.00	39,590.00	10,619.00
L
M			112.00	112.00	5,605.00	5,605.00	4,248.00

Can someone advise me how to do this in Alteryx?

Thank you much

[Jean-Balteryx]

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]

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]

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]

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 · Accepted solution]

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]

Hi @nphuong84 ,

Did you solve your problem ?

Kind regards,

Jean-Baptiste

[nphuong84]

Hi Jean,

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

Thank you so much.

[Jean-Balteryx]

My pleasure @nphuong84.

Have a great day !

Kind regards,

Jean-Baptiste