Browsing non-match data - 8.0

Talend Real-Time Big Data Platform Getting Started Guide

Version
8.0
Language
English
Operating system
Real-Time Big Data Platform
Product
Talend Real-Time Big Data Platform
Module
Talend Administration Center
Talend Installer
Talend Runtime
Talend Studio
Content
Data Quality and Preparation > Cleansing data
Data Quality and Preparation > Profiling data
Design and Development
Installation and Upgrade
Last publication date
2024-04-15
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 Talend Studio.

  • You have created and executed a column analysis.

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.