Create Advanced Filters for Importing Data from a Database

When you are importing data from a database, you can use advanced filters, or conditions, to determine which data to import.

To filter the data to import based on a complex expression

1. Build a query in the Query Builder pane of the Import from Tables dialog.
2. Click Filter in the toolbar. The Filters dialog opens.
3. Click Add Condition. The New Condition/Condition Editor dialog opens.
4. Enter the condition you want to define in the Expression pane. As you type, matching functions and columns appear that you can select for use in your condition.
5. To insert a function into the condition, click Insert and choose Functions, the function type (for example, Basic Functions, Math Functions, etc.), and the function (for example, Add, Average, etc.) to use. The Function Arguments dialog opens.
6. Enter the function arguments in the text fields. As you type, a list of matching functions and columns appear that you can select for use in your function arguments. Function arguments examples appear below each text field.
7. Click OK. Your function appears in the Expression pane.
8. Click Validate to check your condition for valid syntax.
9. If you need to clear the Expression pane to start over, click Clear.
10. Click OK to apply your changes and return to the Filters dialog.
11. If you add multiple conditions, an AND operator is used to join them. To change the operator, click the AND operator between the filters whose operator you want to specify, then click the operator to use (that is, OR, AND NOT, OR NOT).
12. To edit a condition, double-click it.
13. To delete an individual condition, hover over it and click Delete.
14. To delete all conditions, click Delete All.
15. Click Save in the Filters dialog to add the new filters. A filter icon appears next to the data column name.