About: This article introduces the Filter node, a Process node within Construct.
Location: Node panel
Table of Contents
Feature Overview
The Filter node is used to select only certain records that meet a set of user-defined criteria.
Defining a Cohort
All available columns are shown in the list on the left side of the Filter window. To establish a rule each record must meet to be included in the cohort, select a column from the list, then select the operator from the dropdown menu:
- In (specified list)
- Not In (specified list)
- Contains (found within column value)
- Does Not Contain (not found within column value)
- Starts With (the specified value)
- Ends With (the specified value)
- Like (matches a pattern)
- Equals (=)
- Not Equals (<>)
- Greater Than (>)
- Greater Than or Equal To (>=)
- Less Than (<)
- Less Than or Equal To (<=)
- Between (two specified values)
- Is Missing (no value exists)
- Is Not Missing (a value exists)
- EXPRESSION (offers range of DATE-specific operators that rely upon the computer system clock for reference, such as TODAY)
Then enter the value(s) that the selected column should be compared to.
Tip: Using the Get Values button allows the user to view and select values from a list of every distinct value that exists within the column. Holding the Ctrl key allows for multi-selection.
Defining Multiple Conditions
Once a condition is defined, it is added to the Filter by clicking the Add Filter button (green funnel). The condition will then appear as a corresponding SQL statement in the bottom section. Conditions may be removed or deleted by selecting the Filter statement and then clicking the Delete Filter button (blue funnel).
Multiple conditions may be combined to construct sophisticated filtering criteria. The following tools are provided to facilitate this.
Insert/Remove Parenthesis
Parentheses may be useful when combining several conditions. The parentheses are used to group criteria together so they can run together instead of separately. To add parentheses to the Filter statement, select the desired point in the statement and use the Open/Close parenthesis button. To remove parentheses, select the desired parenthesis and then use the arrows next to the Open/Close parenthesis buttons to select Remove Open/Close parenthesis.
And/Or Statements
Multiple conditions may be joined together by adding AND or OR operators between them. The default operator when multiple conditions are added is AND. To change either operator to the other, select the value then click the desired operator button to change it.
Move Up/down
If there is more than one condition defined, the order of the conditions within the statement can be changed. To do this select the desired condition and use the black Move up/Move down buttons to reorder the statement.
Delete all Filters
This button deletes all of the conditions from the filter.
Filtering Parameter
This button appears in conjunction with most operators. When selected, it opens a list box, allowing the user to select a pre-defined parameter to incorporate in the filter statement. Parameters (named variables) are user-defined, specific to each job and configured under the Edit Parameters button of the Job Toolbar. To learn more about job parameters, click here.
Comments
0 comments
Article is closed for comments.