Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Need help with Resident load and apply map

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!

1 Solution

Accepted Solutions
preminqlik
Valued Contributor II

Re: Need help with Resident load and apply map

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 Replies
MVP
MVP

Re: Need help with Resident load and apply map

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
Valued Contributor II

Re: Need help with Resident load and apply map

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

Not applicable

Re: Need help with Resident load and apply map

It works. Thank you so much for you help.

ngulliver
Valued Contributor III

Re: Need help with Resident load and apply map

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

Community Browser