Skip to main content

Varicent ELT Help Center

Filter data

Abstract

The Filter data option allows you to import a subset of your data rows based on your defined conditions.

The Filter data functionality allows you to import a subset of your data rows based on your defined conditions. This will enable you to import only rows matching your conditions and exclude rows you do not want or need. The data will filter according to the conditions that you set.

Important

This step is optional during the importing data process.

Configure Filter data option

You can use the following configuration options to help filter your data upon import.

On the Filter data page during the Import data flow, configure the following fields:

  • Select a column: Select the column from the drop-down menu that contains the values that you want to filter by during import.

  • Filter category: Select the filter category. Learn more...

  • Value or text: Select another column from your data set to compare against or enter a fixed value.

  • + Statement: (Optional) Add an and or or statement for additional filtering.

    • and Statement: Filters data based on the specified conditions. Only rows that meet the conditions in all and statements will be imported.

    • or Statement: Filters data based on the specified conditions. Only rows that meet the conditions in at least one or statement will be imported.

Filter categories

Choose any of the following categories to filter your data with:

Category

Description

Equal

Keeps rows whose value in the selected column is equal to the other value.

Not Equal

Keeps rows whose value in the selected column is not equal to another value.

Less Than

Keeps rows whose value is less than another value.

Less Than or Equal

Keeps rows whose value is a lesser value than or equal to another value.

Greater Than

Keeps rows whose value is greater than another value.

Greater Than or Equal

Keeps rows whose value is greater than or equal to another value.

Is Null

Keeps rows when there is no value in the data.

Is Not Null

Keeps rows when there is a value in the data.

Starts With

Keeps rows with values that start with a specified value.

Ends With

Keeps rows with values with that ends with a specified value.

Contains

Keeps rows whose value contains a specified value.

Not Contains

Keeps rows whose value doesn't contain a specified value.

Usage examples

Use the Filter data option during data import for various reasons to omit data:

  • Filter ensures that you bring in relevant historical data. Importing the proper data ensures that you achieve clearer results.

  • Limit information to users who are eligible to a certain amount of information. Import the eligible information only.