Lookup Tables in Transformation Lite

bijkler

• March 03, 2008 00:00

• Answered

Follow

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

- Mat

• 

  jurban

  • March 03, 2008 13:42

  0

  Comment actions Permalink

  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

Please sign in to leave a comment.