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:

Numeric and Date columns:

  • Equals
  • Does Not Equal
  • Greater Than
  • Greater Than Or Equals
  • Less Than
  • Less Than Or Equals
  • Between
  • Is A Number
  • Is Not A Number

String (Case-sensitive) columns:

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

1. Input

The Filter transform requires 1 input transform that has at least 1 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

Steps to configure the Filter transform:

  1. Select the column(s) you want to be included in the output.

    Filter transform configuration - Step 1
    Filter transform configuration - Step 1

  2. Enter the Operator:
      • And Operator - This is the default selection.
      • Or Operator

    Filter transform configuration - Step 2
    Filter transform configuration - Step 2

  3. Click the Edit icon for the column you want a filter added to.

    Filter transform configuration - Step 3
    Filter transform configuration - Step 3

  4. In the Transform Element dialog, select the Element operator.

    Filter transform configuration - Step 4
    Filter transform configuration - Step 4

  5. Enter the Value.

    Filter transform configuration - Step 5
    Filter transform configuration - Step 5

Icons are slightly different for columns with existing filters.

Column with existing filter
Column with existing filter

3. Output

The figure below illustrates the output from the Filter transform. Only OrderQty greater than 5000 are displayed.

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