This shows you the differences between two versions of the page.
transformations:cleanup [2016/06/19 23:54] (current)
|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.|
|+||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.|