Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi help me.
I have this items
ITEM TABLE
Item Code
ACC001
LTP334
MEM455
GIG991
how can I apply map?
CLASS
Code Classname
ACC Accesory
LTP Laptop
Mem Memory
Please use apply map. I'm using QV11... It dares me coz it does not run, dont know why!
And note that the last item GIG991 not exist in CLASS so it's automatic that the classname for this item is OTHERS.
I really need help. Thanks.
-Bill
load [Item Table];
classmapping:
mapping LOAD * INLINE [
Code, Classname
ACC, Accesory
LTP, Laptop
Mem, Memory
];
load
[Item Code],
applymap('classmapping', left([Item Code],3),'Others' as Classname
resident [Item Table];
How dare you sir! ApplyMap() is awesome!!
Hi Bill,
Please mind your language and keep it thoughtful: it's very different to ask for help that to ask for your work done. While the latter may prevent people to help you, the former will attract people to suggest. I'd strongly recommend you to check here on how to get the best from QlikCommunity.
Regards.
Miguel
Hi, Bill.
There is some useful advice on ApplyMaps here:
http://www.quickintelligence.co.uk/applymap-is-it-so-wrong/.
It's worth a look to give you an idea of it's true capabilities.
Cheers,
Neil