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
Solved! Go to Solution.
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
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
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
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
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
Hi Jean,
It worked, even though my raw data have more than 5000 rows.
Thank you so much.