Mapping load inline multiple value

[#1]

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?

[Anonymous]

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

[marcus_sommer]

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

[sunny_talwar]

Using lookup is another option

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

[marcus_sommer]

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

[sunny_talwar]

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