Browsing non-match data - 6.2

Talend MDM Platform Getting Started Guide

EnrichVersion
6.2
EnrichProdName
Talend MDM Platform
task
Administration and Monitoring
Data Governance
Data Quality and Preparation
Installation and Upgrade
EnrichPlatform
Talend Administration Center
Talend CommandLine
Talend DQ Portal
Talend ESB
Talend Installer
Talend MDM Web UI
Talend Runtime
Talend Studio

After running the column analysis, you can access a view of the matching and non-matching data. This could be very helpful to see invalid rows for example and start analyzing what needs to be done to validate and cleanse such data.

Prerequisites:

  • You have opened the Profiling perspective in the Studio.

  • You have created and executed a column analysis. For further information, see Identifying anomalies in data.

  • In the Analysis Results view, right-click the Blank Count in the statistic results of the Email column and select View rows for example.

    A view opens listing all the blank rows in the Email column.

  • In the Analysis Results view, right-click the result in the Pattern Matching of the Email column and select View invalid values for example.

    A view opens listing all the invalid email addresses.