Filter

Contents[Hide]

The Filter transform filters out rows that do not meet the configured criteria/settings. For example, use this transform when all of the data being read from a data source is not required and the data source doesn’t allow querying (e.g., XML).

Transform - Filter
Transform - Filter

The following are some of the filter operators available in a Filter transform:

Date columns:

  • Equals
  • Does Not Equal
  • Less Than
  • Less Than Or Equal
  • Greater Than
  • Greater Than Or Equal
  • Between
  • Not Equals Value Or Is Null

Numeric columns have additional options, such as:

  • Between
  • Contains Any
  • Is A Number
  • Is Not A Number
  • Is A Number

String columns have further additional options:

  • Contains
  • Does Not Contain
  • Starts With
  • Ends With
  • Equals Any
  • Contains All
  • Contains None
  • Matches Regular Expression
  • Does Not Match Regular Expression

1. Input

The Filter transform requires one input transform that has at least one column.

The input could be a SQL Select transform, or the result of another transform. For example, we'll use the output of the Aggregate transform, as seen below:

Input Data: Sum of OrderQty Grouped by ProductID
Input Data: Sum of OrderQty Grouped by ProductID

2. Configure

Uncheck any column(s) you don't want to be included in the output. These can still be used to filter the records.

Filter transform configuration
Filter transform configuration

Click the Edit icon for a column to filter by its values.

Edit a column's filtering
Edit a column's filtering

In the Transform Element dialog, select the Element Operator.

Select a column condition operator
Select a column condition operator

Operators compare against one or more values. Fill in the fields that follow (e.g., Value).

Enter filter values
Enter filter values

Click the submit button at the bottom of the dialog. The icon will now indicate its filtering with a distinct icon.

Column with existing filter
Column with existing filter

When filtering by more than one column's values, use the Operator setting in the Filter dialog to determine whether all of the conditions must be met (And Operator) or any of the conditions must be met (Or Operator) for records to be included.

Set filter operator
Set filter operator

3. Output

The figure below illustrates the output for our example. Only rows with OrderQty greater than 5000 are included.

Output - OrderQty greater than 5000
Output - OrderQty greater than 5000

4. See also

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours: 7am-6pm, ET, Mon-Fri