Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Valued Contributor

Apply map()

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.

1 Solution

Accepted Solutions
Highlighted

Re: Apply map()

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.

View solution in original post

2 Replies
Highlighted

Re: Apply map()

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.

View solution in original post

Highlighted
Valued Contributor

Re: Apply map()

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

thank you for correcting me