Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
Not applicable

Nest limit 100, need help with mapping values

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.

1 Solution

Accepted Solutions
vishsaggi
Esteemed Contributor III

Re: Nest limit 100, need help with mapping values

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

So

MappingLoad:

Mapping Load Keyvalue,

                        MappingValueField

               FROM yourexcelpath;

Final:

LOAD *,

           ApplyMap('MappingLoad', MappingValueField)  AS YourItem

FROM yourdatasource;

Something like above.

2 Replies
vishsaggi
Esteemed Contributor III

Re: Nest limit 100, need help with mapping values

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

So

MappingLoad:

Mapping Load Keyvalue,

                        MappingValueField

               FROM yourexcelpath;

Final:

LOAD *,

           ApplyMap('MappingLoad', MappingValueField)  AS YourItem

FROM yourdatasource;

Something like above.

Not applicable

Re: Nest limit 100, need help with mapping values

thanks!