Skip to Content

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

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply