Discussion Board for collaboration on QlikView Scripting.
I want to use applymap but I cannot get it to work. I have tried executing a simple example so i could then apply that to what I need but I can't get the simple example to work! :
Table importing from Excel:
Code in script:
ApplyMap('ColourDesc',Colour, 'Unknown')as AColour;
(biff, embedded labels, table is Sheet1$);
To me it looks the same as all the examples I have looked at but it doesn't want to work as the description is not assigned to AColour
Go to Solution.
Load the mapping table first
LOAD * INLINE [
ApplyMap('ColourDesc',Colour, 'Unknown') as AColour;
first u need to have mapping table then u should have the actual code for calculation
I said it was simple....
I have wasted half an hour on that.
Thanks very much