Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.
thanks!