Browsing non-match data - 6.5

Talend Real-Time Big Data Platform Getting Started Guide

author
Talend Documentation Team
EnrichVersion
6.5
EnrichProdName
Talend Real-Time Big Data Platform
task
Data Quality and Preparation > Cleansing data
Data Quality and Preparation > Profiling data
Design and Development
Installation and Upgrade
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.

Before you begin

  • 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.

Procedure

  1. 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.

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

Results

A view opens listing all the invalid email addresses.