Creating "or" conditions on numerical data - Cloud

Talend Cloud Data Preparation Quick Examples

EnrichVersion
Cloud
EnrichProdName
Talend Cloud
EnrichPlatform
Talend Data Preparation
task
Data Quality and Preparation > Cleansing data

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.