Map_id not found in QlikView 12

[Anonymous]

Hi All

I am getting map_id not found error while loading these tables,can anyone please help me with this

Billing:

Load Region,Country,Net,Tax ,Months,

     ApplyMap('MapRegion',Region) as RegionName,

     ApplyMap('MapCountry',Country) as CountryName

From E:\CustomerData.xlsx;

[MapRegion]:

Mapping LOAD * Inline [

Region, RegionFullForm

AP,APAC

CALA,CALA

EMEA,EMEA

US,NORTH AMERICA

];

[MapCountry]:

Mapping LOAD * Inline [

Country,CountryFullForm

AR,Argentina

AT,Austria

BE,Belgium

BR,Brazil

CA,Canada

CZ,Czech Rep.];

[awhitfield]

Hi Vani,

any chance that you can upload your data source .xlsx?

Andy

[sunny_talwar · Accepted solution]

I hope you are loading your Billing table after the two mapping load and not how you have put them above?

[MapRegion]:

Mapping LOAD * Inline [

Region, RegionFullForm

AP,APAC

CALA,CALA

EMEA,EMEA

US,NORTH AMERICA

];

[MapCountry]:

Mapping LOAD * Inline [

Country,CountryFullForm

AR,Argentina

AT,Austria

BE,Belgium

BR,Brazil

CA,Canada

CZ,Czech Rep.];

Billing:

Load Region,Country,Net,Tax ,Months,

     ApplyMap('MapRegion',Region) as RegionName,

     ApplyMap('MapCountry',Country) as CountryName

From E:\CustomerData.xlsx;

[Anonymous]

Ya Sunny,now this was resolved.Thank you