Skip to main content Skip to complementary content

Browsing non-match data

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.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!