topic Re: Apply map() in QlikView

Apply map()

kakani87 — Fri, 01 Jun 2018 13:37:03 GMT

Hi Everyone ..

I'm having two tables

Tab1:

Itemfamilycode

,Itemcode

Tab2:

Itemcode

,sale

,date

,branch

Now i want to get itemfamilycode into tab2

so using applymap() like below syntax

Tab1:

Mapping Load

Itemfamilycode

,Itemcode

Tab2:

Itemcode

,applymap('Tab1',Itemcode) as Itemfamilycode

,sale

,date

,branch

But Itemcode able to get in place of Itemfamilycode

any help in getting Itemfamilycode into tab2

Regards,

Kakani.

Re: Apply map()

Miguel_Angel_Baeyens — Fri, 01 Jun 2018 13:46:19 GMT

It's the other way around, in the MAPPING table always put first the value to be looked up, in this case, Itemcode, and the second, the value you want to have returned, in this case, Itemfamilycode. If there is no match, then the original Itemcode will be displayed. To avoid it, you can use a third parameter in ApplyMap()

ApplyMap('Tab1', Itemcode, 'N/A') AS Itemfamilycode

If Itemcode does not have a match in Tab1, the field will store "N/A" instead.

Re: Apply map()

kakani87 — Fri, 01 Jun 2018 14:27:05 GMT

Yes the mistake I'm doing is putting lookup field in the send row

thank you for correcting me