Filtering values manually

Talend Data Preparation User Guide

author
Talend Documentation Team
EnrichVersion
6.4
2.1
EnrichProdName
Talend MDM Platform
Talend Real-Time Big Data Platform
Talend Data Services Platform
Talend Big Data
Talend Data Management Platform
Talend Data Fabric
Talend ESB
Talend Data Integration
Talend Big Data Platform
task
Data Quality and Preparation > Cleansing data
EnrichPlatform
Talend Data Preparation

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.

Procedure

  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.

Results

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.