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 | |
