Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm a beginner in Qlikview and want to seek help on following script. Not sure why it is not working.
[New Product Approval New]
Load* APPLYMAP('Map_Region', [New Product Approval.Country_List]) As Region
Resident [New Product Approval];
DROP [New Product Approval New];
Thank you!
once check, you are dropping your newly created table.....and write ", " after *
like below :
[New Product Approval New]:
Load *,
APPLYMAP('Map_Region', [Country_List],null()) As Region
Resident [New Product Approval];
drop table [New Product Approval];
Hi,
Try like this
Map_Region:
Mapping LOAD
*
FROM Master;
[New Product Approval New]
Load*, APPLYMAP('Map_Region', [Country_List]) As Region
Resident [New Product Approval];
DROP [New Product Approval New];
Regards,
Jagan.
once check, you are dropping your newly created table.....and write ", " after *
like below :
[New Product Approval New]:
Load *,
APPLYMAP('Map_Region', [Country_List],null()) As Region
Resident [New Product Approval];
drop table [New Product Approval];
It works. Thank you so much for you help.
Hi, Jasmine.
If you want a bit of help with ApplyMap, have a look at Steve Dark's blog
http://www.quickintelligence.co.uk/applymap-is-it-so-wrong/
Steve also has a number of other blogs for beginners.
Cheers,
Neil