topic Re: mapping load in QlikView

mapping load

ilanbaruch — Tue, 31 Mar 2015 10:36:27 GMT

hi all,

any ideas why this mapping wont work?

Country_Map:
Mapping LOAD *inline [
COUNTRY_CODE, COUNTRY
    AF, Afghanistan
    AL, Albania
    AT, Austria
    AZ, Azerbaijan
    BS, Bahamas
    BH, Bahrain
    BD, Bangladesh
];

ApplyMap ('CountryMap',COUNTRY_CODE) as Country,

Re: mapping load

ashfaq_haseeb — Tue, 31 Mar 2015 10:38:26 GMT

Hi,

This is not the right format.

Check below post

Mapping as an Alternative to Joining

Regards

ASHFAQ

Re: mapping load

maxgro — Tue, 31 Mar 2015 10:40:49 GMT

this works

Country_Map:

Mapping LOAD * inline [

COUNTRY_CODE, COUNTRY

AF, Afghanistan

AL, Albania

AT, Austria

AZ, Azerbaijan

BS, Bahamas

BH, Bahrain

BD, Bangladesh

];

Country:

LOAD COUNTRY_CODE,

ApplyMap ('Country_Map', COUNTRY_CODE) as Country

inline [

COUNTRY_CODE

];

here you need a space in *inline

Mapping LOAD *inline [

here the name of the mapping table is wrong

ApplyMap ('CountryMap',COUNTRY_CODE) as Country,

Re: mapping load

rubenmarin — Tue, 31 Mar 2015 10:43:02 GMT

Hi ilan, your map is called 'Country_Map', not 'CountryMap', is this a typo in the post? Try:

ApplyMap ('Country_Map',COUNTRY_CODE) as Country,

(Assuming this is part of a LOAD sentence)

Re: mapping load

Tue, 31 Mar 2015 10:47:02 GMT

hiii ilanbaruch

Try this expression

Country Map:
Mapping

LOAD *inline

[
COUNTRY_CODE, COUNTRY
    AF, Afghanistan
    AL, Albania
    AT, Austria
    AZ, Azerbaijan
    BS, Bahamas
    BH, Bahrain
    BD, Bangladesh
];

Country:

Load Country Code

ApplyMap ('Country Map',COUNTRY_CODE) as Country

Inline

[

Country Code

];

Re: mapping load

Tue, 31 Mar 2015 10:50:59 GMT

Please also note ilan,

ApplyMap ('Country_Map',COUNTRY_CODE) as Country,

that COUNTRY_CODE is the field you are using in your loading table so you may have created your inline map with that field name (which you don't have to do) but it's the field name in your table that must be in the second parameter of the applymap. So just check the spelling of the table field too

hope that helps

Joe

Re: mapping load

ilanbaruch — Tue, 31 Mar 2015 11:03:14 GMT

CountryMap:
Mapping LOAD * inline [
COUNTRY_CODE, COUNTRY
AF, Afghanistan
AL, Albania
DZ, Algeria
AD, Andorra
AO, Angola
AG, Antigua
AR, Argentina
AM, Armenia

];

ApplyMap ('CountryMap',Text(COUNTRY_CODE),null())as Country,

I tried this..still wont work

Re: mapping load

rubenmarin — Tue, 31 Mar 2015 11:18:37 GMT

Hi ilan, it's working? As I see it solved I'm not sure