How to remove columns that are all zeros

[acaryasin01]

Hi,

I have a large data set that has a number of columns that are just all zeros and I want to remove these field.

If there is anything other than zero in the column, it is useful and I would like to keep it. Sample input and output below.

Thanks in advance.

Input
Order #	A	B	C
1001	0	5	0
1002	0	0	0
3302	0	0	2
4507	0	1	1
Desired Output
Order #	B	C
1001	5	0
1002	0	0
3302	0	2
4507	1	1

[DataNath · Accepted solution]

Hey @acaryasin01, here's how I'd go about it. The Data Cleanse tool has the option to remove fully null columns, as well as replace numeric nulls with 0 and therefore I just temporarily made all 0s into nulls in the step before to then push the data through this tool and get the expected outcome.

[acaryasin01]

Perfect, thank you @DataNath much appreciate .

[flying008]

Hi, @acaryasin01 

There is a easy way .