-
On the Link Properties dialog, select the Source tab.
-
Select Filter the source table to enable filtering during the import process.
-
Select Modify to open the Import Source Filter dialog.
-
To create a filtering condition, do one or more of the following:
-
In the Source table columns data window, double-click the table column that you want to add to the filter condition in the data window.
-
Under Operators and functions, select the appropriate operator or function buttons to add the appropriate operator or function to the filtering condition.
-
Under Operators and functions, select a SQL function from the appropriate list. Then right-click the selected SQL function to be applied in the filter condition.
-
In the Import Source Filter dialog, type the appropriate expression. You can also add this expression to the filtering condition already displayed in the Import Source Filter data window.
-
The Filter feature provides you with various built-in operators and functions. For details, see Built-In Operators and Functions. The built-in operators and functions are those used in the WHERE SQL statement. See your database platform manual to learn more about database statements.
-
The Filter feature also provides you with special SQL functions, which are native to the source database. For details, see SQL Functions Native to the Source Database.
-
-
Repeat step 4 to add as many table columns, operators, functions and values as required.
The new condition appears in the window of the Import Source Filter dialog, for example:
-
To check the filter condition syntax, select Verify.
An appropriate message is displayed, notifying you that:
-
The condition in the data window is valid – in this case the message also indicates the number of rows that match the condition.
-
The condition in the data window is invalid – in this case you can correct the condition and try again.
-
-
To view the way the filtering condition affects the source data, select View Source.
-
Select OK to close the Import Source Filter dialog and return to the Source tab where your condition appears in the data window.
You can disable the current filtering condition without deleting it. To do this
clear Filter the source table after you define a condition.
-
Under Associate source tables, select Apply to associate additional source data with the source data that you selected when you started this import session. To make the source data definitions, select Define. See Associate Additional Source Data to learn how to do this.
-
Under Process function, select Assign to assign Smart Instrumentation process functions to the imported data based on their instrument types. To make the source data definitions, select Define. For details, see Associate Source Fields with Existing Instrument Types or Set Source Fields as Instrument Type Fields.