merge two fields from different tables in load script

[curiousfellow]

Suppose I have tables numbered from 1 to 5

Table 1 is linked with table 2

Table 1 is linked with table 3

     Table 3 is linked with table 4

          table 4 is linked with table 5

Now I want to merge  a field from table 2 with a field in table5  in the load script.

I succeeded in this by using the loopup function and temporary tables, but I wonder if there is a way to do this with a shorter method

[khan_imran]

Hi,

Join your table 5 with table 3 using left join or concatenate function based on the data set within 2 table.

Regards,

IK

[marcus_sommer]

Aren't there any other possible associations (maybe some table could be enriched or another table could be a bridge) then you would need several additionally steps to merge these fields. Not necessarily with temporary tables because lookup's could be multiple nested whereby I'm not sure if you would get a real benefit from this then it could be slower then with those temp tables.

- Marcus

[Anonymous]

hi,

please post the tables structure or data model,so can help

[curiousfellow]

Unfortunately I can not find another way. I need the new field in table 1 to link with other tables.

So I will have to use the temp tables i guess