Filtering values manually - Cloud

Talend Cloud Data Preparation User Guide

EnrichVersion
Cloud
EnrichProdName
Talend Cloud
EnrichPlatform
Talend Data Preparation
task
Administration and Monitoring > Managing connections
Data Quality and Preparation > Cleansing data
Data Quality and Preparation > Managing datasets

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 create some filters to only display the male customers from California, by using the search field, as well as the Add filter button.

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 with the contains operator.

    Filter badges can be edited to search for any value.

    The Add a filter field is convenient to quickly search for a value across the whole sample, but you can also be more accurate and manually select which column, operator, and keyword to use. You will now apply another filter, to isolate the male customers, among the ones already filtered, this time with the Add filter button.

  3. Click the Add filter button to start creating a new badge.
  4. From the list of columns, select gender.
  5. Select Equal to as operator.
  6. Enter male as keyword, and click Apply to add this filter to the previous one.

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

  7. In the functions panel, click a function to execute it on the data you filtered, Keep these Filtered Rows for example.
  8. 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.