Creating "or" conditions on numerical data - 7.3

Talend Data Preparation Examples

Version
7.3
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
2023-08-07

When working on datasets containing numerical data, you can use a filter to isolate rows that include a specific value, or select a range of values via the Chart panel to create the corresponding filter. However, to create a filter that returns the rows corresponding to a list of values, in other words an "or" filter, you need to proceed differently. You will need to create a regular expression matching all the numerical values of your choice, and filter on rows that match this regular expression.

Using the car dealership dataset, for the sake of the example, you will create a filter to display the sales for cars that were released on specific dates. You will then be able to export the customer information corresponding to this filter only.