Add an Assemble WHERE Clause

An Assemble WHERE clause can be applied to a Target Source, which is then included in a CranPort package to filter Source data when importing or refreshing a Target.

To add an Assemble WHERE clause in Map:

  1. Select ProcessArea in the Navigation pane.
  2. Click the Targets icon on the Process Area Launch page.
  3. Click the Sources icon for a Target.
  4. Click Vertical View for the Target Source that contains the column used in the WHERE clause.
  5. Click Edit.

    View the field descriptions for the Target Sources page's Vertical View

  6. Enter the WHERE clause in the Assemble Where Clause field.

    NOTE: The WHERE clause must consist of a column name, an operator and a value. For example, Country = 'US'.

  7. Click Save.