transformations:cleanup
Differences
This shows you the differences between two versions of the page.
| — |
transformations:cleanup [2016/06/19 23:54] (current) dmitry created |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | ===== Clean up ===== | ||
| + | Remove from column particular values or values of a particular type (e.g. text) by replacing them with empty cells. Unlike [[transformations:selectionfilter|Filter]] this transformation doesn't remove table rows. | ||
| + | |||
| + | **Use cases** | ||
| + | Clean Up is used for dealing for data quality issues. E.g. removing text values from a column where only numbers are expected, or removing particular (garbage) values. Most typically, Clean Up is used when importing data from Excel spreadsheets. | ||
transformations/cleanup.txt · Last modified: 2016/06/19 23:54 by dmitry
Page Tools
