Skip to Content

Looking at the Lookup_ext Function

This how to document covers Data Services 4.0 SP1

The Lookup_ext(), or Lookup Extended function allows for complex joins, return multiple values, and a flexible return policy (multiple returns).

Double click on the Query Transform and delete the default mapping for country.

/wp-content/uploads/2012/12/1figdelete_169753.png

Click the Functions button and select Lookup Functions > lookup_ext

/wp-content/uploads/2012/12/2functions_169757.png

Select Next

/wp-content/uploads/2012/12/3parameter_169758.png

Enter as shown above.  The lookup table is ALPHA.COUNTRY (which has country name).  The lookup is based on country ID.

The output is country name.

Finish

Execute the job

View the data in the target table and notice that Country Name is now populated

/wp-content/uploads/2012/12/4viewdata_169759.png

Be the first to leave a comment
You must be Logged on to comment or reply to a post.