Lookup Tables in Transformation Lite

Is it possible to use the contents lookup table in a REFORMAT transformation using only a Transformation Lite script.

- Mat

Hi,
yes it is possible by using the Lookup Join component. Just specify that you want to read from the 1st source, not from the 0th. For example:

${in.1.lastName}

The code above reads the “lastName” field of the lookup table.

Jaro