In predicate

When you specify an In predicate in the expression editor, you choose a column, select items to include in the query, and specify whether selected values are in the list or not in the list.

The expression editor when you have selected the In predicate contains:

  • Column. Choose the column on which you are filtering from the drop-down list. You can specify one of the following in identifying a column:
    • Job parameter. A dialog box appears offering you a choice of available job parameters. This allows you to specify the value to be used in the query at run time (the stage you are using the SQL builder from must allow job parameters for this to appear).
    • Expression. An expression editor dialog box appears, allowing you to specify an expression that represents the value to be used in the query.
    • Data flow variable. A dialog box appears offering you a choice of available data flow variables (the stage you are using the SQL builder from must support data flow variables for this to appear)
    • Column. You can directly select a column from one of the tables in the table selection canvas.
  • In/Not In. Choose IN or NOT IN from the drop-down list to specify whether the value should be in the specified list or not in it.
  • Selection. These fields allows you to specify the list used by the query. Use the menu button to the right of the single field to specify details about the argument you are using to specify a list item, then enter a value. Click the double right arrow to add the value to the list.

    To remove an item from the list, select it then click the double left arrow.