Matching projects applies the matching policy in the Knowledge Base to an existing dataset and provides output that can be exported in different formats. In this example, we will create a matching project to apply the matching policy of the previous example to a dataset and we will see the options for exporting data. Perform the following steps:
Create a new data quality project and name it
Sample Matching Project
forPacktPub_Movies
. Use thePacktPub_Movies_KB
Knowledge Base for this. Select activity as Matching and click on Next.In the Map step, select source as Excel, file as
MoviesSampleData.xlsx
, and map Director and Title from the input columns to the Knowledge Base domains.In the Matching step, click on Start to apply matching policy on the dataset. You will see a view of matched and unmatched data rows; click on Next.
In the Export tab, set destination type as Excel, export the results of matching and survivorship to different Excel files, and export...