no way to compare when less than two revisions

Differences

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

@@ 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.