User Tools

Site Tools


transformations:cleanup

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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