topic Re: Need help with Resident load and apply map in QlikView

Need help with Resident load and apply map

Fri, 10 Jan 2014 15:28:29 GMT

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 — Fri, 10 Jan 2014 16:00:07 GMT

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 — Fri, 10 Jan 2014 16:42:01 GMT

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

Fri, 10 Jan 2014 20:36:30 GMT

It works. Thank you so much for you help.

ngulliver — Sun, 12 Jan 2014 20:03:06 GMT

Hi, Jasmine.

If you want a bit of help with ApplyMap, have a look at Steve Dark's blog

Steve also has a number of other blogs for beginners.

Cheers,

Neil