You can create a filter to control the data included in your data flow. A filter creates WHERE criteria in the SQL of your flow. You can filter your data with a constant value or a variable.
Note: When a filter is saved, it is parsed and any superfluous parentheses are removed.
The WHERE Filter Calculator opens.
From the data flow workspace:
The WHERE Filter Calculator opens.
Note: If the Relational Expression tab is not selected, click on it to select it.
The column is added to the Conditions field.
From the data flow workspace:
The WHERE Filter Calculator opens.
Note: If the Relational Expression tab is not selected, click on it to select it.
The column is added to the Conditions field.
From the data flow workspace:
The WHERE Filter Calculator opens.
The column is added to the Conditions field.
For more information about variables, see Using Variables in a Flow.
A filter that uses a sub-select can be typed in to the filter calculator or created using the Function Assist.
The WHERE Filter Calculator opens.
Note: If the Conditions tab is not selected, click on it to select it.
(test_exp1, test_exp2) IN (SELECT exp1, exp2 FROM mfd WHERE condition)
T1.PLANT IN (SELECT T2.PLANT FROM DMSALE T2 )
You can also select rows where the combination of values of PLANT and ORDER_NUM are found in DMSALE.
(T1.ORDER_NUM ,T1.PLANT ) IN (SELECT T2.ORDER_NUM , T2.PLANT FROM DMSALE T2 )
The WHERE Filter Calculator is available from the data flow workspace by right-clicking the SQL object and selecting WHERE Filter.
The Filter Calculator contains the following fields and options. For a full description of the operators available, see Join Calculator.
Displays the expression.
Displays the Relational Expressions builder.
Tests the SQL statement and displays the result.
Note: The test button will be grayed out if you have not selected any columns.
Displays available columns and variables in a hierarchical tree view or in a list view.
When displayed in a tree view, expanding the column name shows a list of values.
For a synonym for data source in a table or file, a query is done to the data source to get a list of unique values. For large data sources, this could take a while.
For a synonym for a database stored procedure, a web service, application adapter, or other procedure based adapter list of acceptable values is retrieved from the synonym.
Displays a list of SQL functions that are available for your transformations.
Allows you to specify parameters for the function through a dialog box when creating or editing a transformation.
Insert numbers and operators.
Adds parentheses.
Inserts two single quotation marks. Enter alphanumeric test values between these.
Converts selected text to uppercase.
Converts selected text to lowercase.
Opens the Date Editor window which lets you use the current date, or specify a date from the calendar.
Opens the Date Editor window which lets you use the current date and time, or specify a date and time from the calendar.
iWay Software |