Filtering values manually - 6.5

Talend Data Preparation User Guide

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
Talend Data Preparation
Data Quality and Preparation > Cleansing data

In order to have a more specific idea of the data contained in your dataset or in order to perform functions on a certain subset of data, you can create a filter on your data.

This example uses a dataset with typical customer information, such as their names, age, email or state they live in. You are going to manually enter some filters to only display the male customers from California.


  1. In the Add a filter field on the top left of the grid, start typing the value you want for your filter, california in this example. Talend Data Preparation suggests columns containing this value.

    The suggestions are based on the data that is contained in the sample.

  2. Select california in state to only display the entries corresponding to this location.

    You can see in the Filter bar that the filter has been correctly applied.

    Filter badges can be edited to search for any value.

    You will now apply another filter, to isolate the male customers, among the ones already filtered.

  3. In the Add a filter field, start typing male.
  4. Select male in gender to add this filter to the previous one.

    The grid now only displays the data corresponding to those two filters

  5. In the functions panel, click a function to execute it on the data you filtered, Keep these Filtered Rows for example.
  6. In the filter bar, click the cross in each individual filter or click the garbage bin icon to clear the filters and display the whole dataset again.


You have filtered your data to isolate a specific customer group and you can start applying function and work on this sample only.

You can apply filters manually, or use the charts panel to create even more complex filters.