Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Data Lookup element in Data Movement Model

Hi all,

I'm new to PowerDesigner and I cannot quite understand how the Data Lookup Element in Data Movement Models works.

Let's say I have two tables PERSON_TABLE ( Person_Name, Country_ID) and LOOKUP_TABLE(Country_ID, Country Name).

I want to lookup Country name in the lookup_table.

I would expect that I have these two tables as and input to Data Lookup.

I don't get how do I set in Data Lookup that the key value in lookup_table is country_id and that it should be joined with country_id from person_table and country_name should be passed further.

Thanks and best regards,


Former Member

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question