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.00A 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

Hide rows with no value

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

Preparation

Accepted answers

Jean-Balteryx

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

Hide_rows_with_no_value.yxmd

All comments

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.