- On the Variable Transformations dialog, click on INPUT.
-
Click on expert options.
Variable Transformation > Input > Expert Options
The resulting screen has the WHERE clause option available:
-
Optional WHERE clause text — Specify a SQL WHERE clause to restrict rows selected for analysis. In this example, the free-form text gender = <g> AND marital_status = <m> includes placeholders for the literal parameters g and m, the values of which are substituted at run time for <g> and <m>, respectively.If a SQL Where clause is entered here, it may be used in more than one context in the generated SQL. It should generally not contain table names or aliases, but simply refer to columns in the table being transformed.
-
Optional WHERE clause text — Specify a SQL WHERE clause to restrict rows selected for analysis. In this example, the free-form text gender = <g> AND marital_status = <m> includes placeholders for the literal parameters g and m, the values of which are substituted at run time for <g> and <m>, respectively.