topic Re: Nest limit 100, need help with mapping values in QlikView

Nest limit 100, need help with mapping values

Wed, 25 Nov 2020 16:16:04 GMT

Hi all.

I have a list of item codes, and they all belong to some overarching item. Like 'F9', 'F9 Pro', 'F9 Billing', are all under the item F9.

I have data that shows customers and all their item codes, but no item. So I have an Excel document that lists all the mappings. I tried to do a long nested if statement in the script, but it is limited to 100, and there are about 120 mappings.

I believe I can map directly through the excel doc, can someone help me with this?

Thanks.

Re: Nest limit 100, need help with mapping values

vishsaggi — Mon, 10 Jul 2017 19:18:15 GMT

Did you try Appymap? You have to load your excel table with two fields one KeyValue and other MappingValue.

MappingLoad:

Mapping Load Keyvalue,

MappingValueField

FROM yourexcelpath;

Final:

LOAD *,

ApplyMap('MappingLoad', MappingValueField) AS YourItem

FROM yourdatasource;

Something like above.

Re: Nest limit 100, need help with mapping values

Mon, 10 Jul 2017 19:33:32 GMT

thanks!