transformations:cleanup
no way to compare when less than two revisions
Differences
This shows you the differences between two versions of the page.
Previous revisionNext revision | |||
— | transformations:cleanup [2021/03/30 22:18] – craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | {{ transformations: | ||
+ | ====== CLEAN UP ====== | ||
+ | Category: Transform / Basic\\ | ||
+ | \\ | ||
+ | =====Description===== | ||
+ | This action removes specified values, or values of a particular type (e.g. text), from a column by replacing them with empty cells. | ||
+ | |||
+ | Unlike [[transformations: | ||
+ | \\ | ||
+ | |||
+ | \\ | ||
+ | =====Use cases===== | ||
+ | //Clean Up// is used for dealing with data quality issues - e.g. removing text values from a column where only numbers are expected, or removing specific undesired values. Most typically, //Clean Up// is used when importing data from Excel spreadsheets.\\ | ||
+ | |||
+ | \\ | ||
+ | =====Action settings===== | ||
+ | ^Setting^Description^ | ||
+ | |Column|Select the specific column that values will be cleaned from.| | ||
+ | |Remove…|Select the types of values, or specific values, to be removed. | ||
+ | \\ | ||
+ | ====Remove options==== | ||
+ | ^Option^Description^ | ||
+ | |Remove numbers|All numeric values are removed.| | ||
+ | |Remove everything but numbers|All numbers are kept; non-numeric values are removed.| | ||
+ | |Remove text values|All text values are removed.| | ||
+ | |Remove everything but text values|Text values are kept; non-text values are removed.| | ||
+ | |Remove whitespace only values|Removes values containing only spaces.| | ||
+ | |Remove errors|All error results are removed.| | ||
+ | |Remove particular values|Options: | ||
+ | |||
+ | \\ | ||
+ | =====Shortcuts===== | ||
+ | Fast ways to create the action:\\ | ||
+ | *Right-click a value and select "Clean Up" | ||
+ | |||
+ | \\ | ||
+ | =====See also===== | ||
+ | * [[transformations: |
transformations/cleanup.txt · Last modified: 2024/04/12 00:35 by craigt