Filter data
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
oror
statement for additional filtering.and
Statement: Filters data based on the specified conditions. Only rows that meet the conditions in alland
statements will be imported.or
Statement: Filters data based on the specified conditions. Only rows that meet the conditions in at least oneor
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.