Skip to main content

Varicent ELT Help Center

Filter

Abstract

Use the Filter tool to explore a subset of your data.

Use the Filter tool to explore a subset of your data. Keep data that passes logical tests.

When to use this tool

Use when you want to explore a subset of your data.

Input

The Filter tool requires one data input.

Configuration

Use the following configuration options to help create your Filter configuration.

Configuring the Filter tool

  1. In , add your data source.

  2. Click symon_add_icon.png + Tool.

  3. In the search bar, search for Filter. Click + Add tool.

    Tip

    You can also find the Filter tool in the Clean section.

  4. Connect the tool to your data set.

  5. In the configuration pane, enter the following information:

    Table 49. Filter tool configuration

    Field

    Description

    Select a column

    Select a column to filter your data with.

    Filter category

    Select one of the following filters to use:

    • Equal

    • Not Equal

    • Less Than

    • Less Than or Equal

    • Greater Than

    • Greater than or Equal

    • Starts With

    • Ends With

    • Contains

    • Not Contains

    • Is Null

    • Is Not Null

    Value or text

    Select the value to use, or start typing to find a value.

    AND + Statement

    Optionally add an AND statement. Filters data based on the specified conditions. Only rows that meet the conditions in all AND statements will be imported.

    OR + Statement

    Optionally add an OR statement. Filters data based on the specified conditions. Only rows that meet the conditions in all OR statements will be imported.

    Switch to advanced

    Click to go to advanced filter rules to add a group or statement.



Usage example

In this example, we have a data set that contains customer IDs and an NPS score.

CustomerID

NPS

2453

2

3243

4

3452

10

4324

6

5324

8

Let's say we want to explore data only for customers considered "detractors" (a score of 6 or less). We can remove the rows we don't need by using the Filter tool:

  1. In the left side literal or column field, select or type "NPS".

  2. Select or type "Less Than or Equal".

  3. In the right side literal or column field, type "6".

As a result, the data set now looks like this:

CustomerID

NPS

2453

2

3243

4

4324

6