Data cleansing in Data Types and Patterns Dashboard

The Data Types and Patterns dashboard is useful for identifying gaps and inconsistencies in data. You can also correct some easy data errors as soon as you find it. If the error is for a categorical property such as gender, location, employment type, then you can simply use drag and drop to correct.

In the example below, in the Gender property we can see that Female has been entered two ways – F and Female.

 

To correct this, pick up the bar under F and drag on the bar under Female. As soon as you drop it the 'Set property value' dialogue box pops up for you to review the list of the nodes that will update its values to Female from F. Click the OK button to make the changes.

 

 

Then click the Refresh button in the toolbar and you'll find that the data is updated and there are now two groups in the Gender property.

Have more questions? Submit a request

Comments