Filtering data against patterns
After analyzing a set of columns against a group of patterns and having the
results of the rows that match or do not match "all" the patterns, you can filter the
valid/invalid data according to the used patterns.
Before you begin
An analysis of a set of columns is open in the analysis editor in the Profiling perspective of Talend Studio.
You have used the Java engine to execute the analysis.
Procedure
-
In the analysis editor, click Data to expand the
corresponding view.
A table lists the actual analyzed data in the analyzed columns.
-
Click Filter data on top of the table.
A dialog box is displayed listing all the patterns used in the column set analysis.
Results
All last names that do not match the selected pattern appear in red.
The Previous and Next buttons under the table helps you to navigate back and forth through pages.
Numbered buttons are displayed under the table to access pages directly:
- When you open the Data view for the first time after running the analysis.
- If you did not select a pattern in the Filter data dialog box.
- If you selected All data as the display option in the Filter data dialog box.