Time for action – using Data Quality Project for cleansing

In this example, we will use the Address KB Knowledge Base to clean the incoming data from an Excel file. There is a point to be noted here; the incoming data has one file for the address—the composite domain named Full Address. So we have to map the incoming address column to this Full Address domain. And then the Knowledge Base will perform the composite domain parsing. There are three types of composite domain parsing: reference data, in-order, and Knowledge Base parsing. In this example, we will use Knowledge Base parsing, which works based on delimiters and Knowledge Base domain values and rules.

We will export the result of the data cleansing to a file at the end. Perform the following steps:

1. Click on Address KB in the list of recent Knowledge Bases and open it in Domain Management mode.

2. Click on the Full Address composite domain and then in the composite domain's Properties tab, at the bottom of domains list, click on Advanced...