topic Re: ApplyMap for multiple IDs inside one field in QlikView

ApplyMap for multiple IDs inside one field

david_pkma — Wed, 25 Nov 2020 16:16:04 GMT

Hello everyone,

I have a Mapping Table like:

MapCustomer:

Mapping LOAD ORGID, NAME

Reisdent Customer;

And now I have one field like:

FieldName: 1,2,3,4

(Comma seperated IDs inside that one field)

Now I want to load in the loading script instead of the FieldName IDs the actual names.

Something like:

LOAD *,
ApplyMap('MapCustomer', SubField(FieldName,','), null()) as AppliedMap
FROM
Source

And the result should be:

AppliedMap: Name1,Name2,Name3,Name4

It should be dynamic, since the count of IDs can vary.

Of course this does not work but I am really missing the point on how to make it work.

Thank you in advance

sunny_talwar — Tue, 31 Jul 2018 15:14:22 GMT

Why don't you use MapSubString instead

MapSubString('MapCustomer', FieldName) as AppliedMap

sunny_talwar — Tue, 31 Jul 2018 15:16:23 GMT

Sample script

MapCustomer:

Mapping

LOAD * INLINE [

ORGID, NAME

1, Name1

2, Name2

3, Name3

4, Name4

];

Table:

LOAD *,

MapSubString('MapCustomer', FieldName) as AppliedMap;

LOAD * INLINE [

FieldName

"1,2,3,4"

];

david_pkma — Wed, 01 Aug 2018 06:29:16 GMT

Oh god, it was that simple all along? I really did not find it in the help.

Thank you so much, it worked!