Cleanup Suggestions assists with the cleanup of data before analysis. This reduces the number of errors in the final report.
Smart Cleanup is activated by clicking in a table, then selecting Data -> Cleanup Suggestions.
This loads the Cleanup Suggestions panel to the right displaying any areas of the data that it believes may cause issues during the analysis phase.
We can see that we have duplicate rows in the data. If this is an issue, hovering over the entries in the list will reveal which items will be kept (green) and which will be discarded (red) if the REMOVE action is invoked.
We also see if there are any extraneous spaces before, after, or in the middle of the data.
Selecting the green checkmark button will accept all suggested modifications while selecting Trim All on a per-column basis allows for more focused correction.
When working with repetitive data, items that frequently occur but with minor variations in spelling will be flagged as Inconsistent Data.
By selecting the green checkmark, the suggested spelling will be applied to all flagged cells.
BEWARE: Not all instances of inconsistent data are discovered, even when a refresh is performed. This is likely due to the relative infancy of the feature and will no doubt discover more inconsistencies as the feature matures.