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.

    Overview of the View rows results.
  2. In the analysis results, 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.

Overview of the View invalid values results

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!