Need help with Resident load and apply map

[#1]

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!

[jagan]

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.

[preminqlik · Accepted solution]

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];

[#4]

It works. Thank you so much for you help.

[ngulliver]

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