Cleaning Data

Undoing Deletions It is possible to undo any deletions made with the clean data utility. Leaving the “Data value is” text field blank is effectively the inverse of placing the global “*” character in that field: the former Data value globally deletes values while the blank field globally restores them. If you select one of […]

Cherry Picking Clean Data If you want to cherry pick values in one go from the Flat Data table, simply put a character (say #) in the column next to the Dimension column and then set Excel to filter on this column (under Data tab on the ribbon “Filter”). Then set the filter to only

Cleaning up Data Figure 1: The clean data main menu. In this example, the cursor was placed on a field that contained a value so that value has been helpfully copied into the “Data Value is:” field. Background: Once you have imported and generated visualisations of your data you can then look for obvious problems.