topic Re: merge two fields from different tables in load script in QlikView

merge two fields from different tables in load script

curiousfellow — Fri, 02 Oct 2015 08:30:18 GMT

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

Re: merge two fields from different tables in load script

khan_imran — Fri, 02 Oct 2015 08:45:56 GMT

Hi,

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

Regards,

Re: merge two fields from different tables in load script

marcus_sommer — Fri, 02 Oct 2015 10:48:41 GMT

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

Re: merge two fields from different tables in load script

Anonymous — Fri, 02 Oct 2015 10:57:55 GMT

hi,

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

Re: merge two fields from different tables in load script

curiousfellow — Fri, 02 Oct 2015 11:32:39 GMT

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