Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Champion III
Champion III

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.

View solution in original post

2 Replies
vishsaggi
Champion III
Champion III

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
Author

thanks!