topic Re: Load script question in QlikView

Load script question

jduluc12 — Sat, 26 May 2018 19:09:14 GMT

Hi,

I have a data set like this

First table:

Itemid	Item	Amount	Addr
1	Item 0	30	FA
2	Item1	30	CA
3	Item2	89
4	Item3	89

Second table:

Item ID	Addr
3	QA
4	C2

I need to merge these tables in the load script so it can fill addr column of First table with the missing value.

Output table:

Itemid	Item	Amount	Addr
1	Item 0	30	FA
2	Item1	30	CA
3	Item2	89	QA
4	Item3	89	C2

What would be the most efficient way to do it?

Thanks

Re: Load script question

Frank_Hartmann — Sat, 26 May 2018 20:21:51 GMT

Use Mapping Load!

Map:
Mapping Load
        [Item ID] as Itemid,
        Addr
FROM [https://community.qlik.com/thread/302853]
(html, codepage is 1252, embedded labels, table is @2);


Final:
LOAD    Itemid,
        Item,
        Amount,
        if(Addr='',ApplyMap('Map',Itemid),Addr) as Addr
FROM [https://community.qlik.com/thread/302853]
(html, codepage is 1252, embedded labels, table is @1) ;

hope this helps

Re: Load script question

jduluc12 — Sun, 27 May 2018 00:20:36 GMT

I had to rename the field else it worked fine.

Thanks