Outputs page - Selection tab

Use the Selection tab to specify optional SQL SELECT clauses for the conditional extraction of data.

This tab is displayed when you select Generated query on the General tab.

The Selection tab contains two text boxes:

WHERE clause: Contains an SQL WHERE clause to select only the data that meets certain criteria or to join two tables from the same data source. You can also use a job parameter in the WHERE clause.

Other clauses: Contains a HAVING clause or an ORDER BY clause. If you use the stage to aggregate data, use a HAVING clause to specify conditions that the grouped data must meet before it is selected. You can also use a job parameter in the HAVING clause. Specify an ORDER BY clause to sort data based on a chosen column.

The SQL SELECT statement is updated automatically after you specify a clause. Click the View SQL tab to display the statement.