User Tools

Site Tools


Clean up

Remove from column particular values or values of a particular type (e.g. text) by replacing them with empty cells. Unlike 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