topic Re: Mapping load inline multiple value in QlikView

Mapping load inline multiple value

Wed, 22 Mar 2017 08:31:28 GMT

Map1:
MAPPING LOAD * INLINE [
COMPANY CODE, CODE
SG, 104_DBU
SG, 105_ACU
HK, 107_HongKongBr
];

Table A:

ApplyMap('Map1', [COMPANY CODE], 'Others') AS [HFM Entity Code]

I created a mapping table and I applied map to one of my tables. However, my [COMPANY CODE] is only picking up the first SG of 104_DBU. How do I make sure SG picks up 105_ACU as well?

Re: Mapping load inline multiple value

Anonymous — Wed, 22 Mar 2017 08:39:09 GMT

I think using joins in this case is a better idea.

Re: Mapping load inline multiple value

marcus_sommer — Wed, 22 Mar 2017 08:54:33 GMT

Applymap() takes only the first matching like a lookup in excel. This meant you need to extend the logic so that each value is unique or you need a different approach - maybe a join like laddu_927 mentioned.

- Marcus

Re: Mapping load inline multiple value

sunny_talwar — Wed, 22 Mar 2017 09:17:37 GMT

Using lookup is another option

Update: Lookup is not an option as Marcus pointed out below

Re: Mapping load inline multiple value

marcus_sommer — Wed, 22 Mar 2017 09:29:34 GMT

Hi Sunny,

I think lookup() will also take the first matching value because from where should these functions know which of these values should be returned.

- Marcus

Re: Mapping load inline multiple value

sunny_talwar — Wed, 22 Mar 2017 09:31:37 GMT

That's true... don't know what I was thinking