User Tools

Site Tools


transformations:cleanup

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
transformations:cleanup [2024/04/12 00:30] – [Description] craigttransformations:cleanup [2024/04/12 00:35] (current) craigt
Line 9: Line 9:
 \\ \\
 =====Use cases===== =====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.\\+//Clean Up// is used for dealing with data quality issues - e.g. removing text values from columns where only numbers are expected, or removing specific undesired values. Most typically, //Clean Up// is used when importing data from Excel spreadsheets.\\
  
 \\  \\ 
 =====Action settings===== =====Action settings=====
 ^Setting^Description^ ^Setting^Description^
-|Column|Select the specific column that values will be cleaned from.|+|Column|Click the down arrow to choose which columns Clean Up will affect.  Options:  //Column// (and select a specific column), //All columns// (to clean the entire dataset), or //Selected columns// (and select which columns will be cleaned).|
 |Remove…|Select the types of values, or specific values, to be removed.  See below.| |Remove…|Select the types of values, or specific values, to be removed.  See below.|
 \\  \\ 
transformations/cleanup.txt · Last modified: 2024/04/12 00:35 by craigt

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki