Filter a data source table

When you filter a data source table, you use a SQL WHERE clause to indicate specific characteristics for the data you want to view. You can access any data that is in the source table. For example, suppose that you are viewing the DEMOG table in the source database, and you want to look at only cases for females. If Gender is stored in the DEMOG table, you can filter by Gender.

1. In the left navigation pane, hover on the Data Analysis icon (), then click Data Mining Runs.
2. From the Project drop-down list, select a project, or select -- to include all projects.
3. From the Configuration drop-down list, select a data configuration, or select -- to include all configurations.
4. Select the Row Action menu icon () for a run, and then click View Jobs for Run.
5. In the upper-right corner, click Sources.
6. Click the name of the data source table that you want to view.
7. Click Filter.
8. In the SQL WHERE clause text box, type a SQL WHERE clause. You can refer to any of the columns listed on the Table Viewing Options page, regardless of whether or not you included them in the displayed table.
9. Click Apply Filter. To remove the filter, click Clear.