Showing results for 
Search instead for 
Did you mean: 

Using a Template Table in a Lookup function

0 Kudos


How can i use a template table in a lookup function?

I heard that you can change the code of an existing lookup by changing the table names, but it is not working. There is no errors when running, but the lookup table columns are not visible.

Can you please advise?

Thank you.

Accepted Solutions (0)

Answers (1)

Answers (1)

Active Contributor
0 Kudos

You cannot use template tables in lookup functions, or in table_comparison transforms for that matter.

An often used workaround consists in defining 2 datastore for the same underlying database. In DS1 you use template tables. The tables you need can then be imported into DS2 for use in functions and the like.