transformations:removeemptycolumns
This is an old revision of the document!
Remove empty columns
This action removes columns with no meaningful information such as empty columns, columns with all values being whitespace, or columns where all values are the same.
The action can be helpful, for instance, after importing spreadsheets with sparsely located tables, or where table position changes from a file to file. It can also be used to remove columns that only contain null replacement values, such as "NULL".
Example
Source dataset:
| Column 1 | Product name | Column 2 | Qty | Column 3 | Price |
|---|---|---|---|---|---|
| Big thing | 1 | 1000 | |||
| Medium thing | 10 | 100 | |||
| Small thing | 100 | 10 |
Objective: remove empty columns.
Result:
| Product name | Qty | Price |
|---|---|---|
| Big thing | 1 | 1000 |
| Medium thing | 10 | 100 |
| Small thing | 100 | 10 |
transformations/removeemptycolumns.1532291265.txt.gz · Last modified: 2018/07/22 16:27 by dmitry