Creating "or" conditions on cities - 8.0

Talend Data Preparation Examples

Version
8.0
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Data Preparation
Content
Data Quality and Preparation > Cleansing data
Last publication date
2024-01-12

To create a condition, or a filter on several text values at the same time, like cities, you can use the Chart panel to select multiple values. You can even use the navigation arrows to browse past the first 10 results. However the statistics from the charts are only based on the 10 000 rows sample. If your dataset is larger than that, just like the car dealership dataset, you may miss potential records that are beyond this sample. So if you want to make sure your filter returns all the matching rows, you need to proceed differently. You will need to create a regular expression matching all the text values of your choice, filter on rows that match this regular expression, and use the Fetch more feature to retrieve all the other rows matching this filter.

Using the previously imported car dealership dataset, you will create a new preparation and create a filter to display the sales that occurred in the five biggest cities in France.