Add expressions on mapped sources

To generate a WHERE clause to filter by column value on the source table(s), restricting the set of source data that participates in the transformation:

1. Select the target table.
2. If needed, add an alias for the source table.

   Note:

   The Logical Name field shows alternate names for the table defined in the data model. These values are used in automapping.

3. In the Mapped Sources tab, click the icon in the Source Filters column and write an expression, either as free text or using the Expression Builder. See Use the Expression Builder for details.

   Important:

   • If you reference a static package or function in free text, you must select it in the Selected Packages tab.

   • In free text, use just the column name, not the table.column format, unless you need to use an alias, as in a self-join. In that case the alias.column format is required.

4. If you reference a static package in free text, you must select it in the Selected Packages tab.