Data (global transformations only)

In this tab, you can create an expression that leverages modified source column data and/or the original source column data. Modified column data is data that has been replaced or modified using a global transformation (e.g. Replace column value) whereas the original source column data is the data as it appears in the source database.

The following options are available:

• $AR_M_MODIFIED_COLUMN_DATA - Use to specify column data that has been replaced or modified using a global transformation.

• $AR_M_SOURCE_COLUMN_DATA - Use to specify the original column data.

   

  Example:

  For a source column called "Age", the following expression can be defined to exclude all records for citizens between the age of 50 and 80.

   

  $AR_M_SOURCE_COLUMN_DATA > '50' AND $AR_M_SOURCE_COLUMN_DATA < '80'