Mapping country

[soniasweety]

Hi all,

Gysbert Wassenaar

Antonio Mancini

I have 3 separate tables .

MD

MI

country codes

so  I need to create one column with region like below,how can I achieve  its like   for one chart I need to show region wise count. nd one chart for separate tables .  [in each table I have several columns but I have given only one column for time being in attached excel]

Region

EMEA

Banglor

United States of America

Melbourne

singapore

Budapa

[soniasweety]

Hi Sunny Talwar ( any help on this?

[sunny_talwar]

You want to map to Region from Country? Is that the goal?

[soniasweety]

yes sunny,

first two sheets code_BB   Code_MI     3rd sheet  we need to map  witht that code and corresponding country and destination

based on that I need one calumn like region which I shown above.

[soniasweety]

simple example is

code_BB   sheet map with countrycode sheet and create one region

Code_Mi     sheet map with countrycode sheet and create one region 

in final I need count(region) for both

[sunny_talwar]

So you need to do something like this

MappingTable:

Mapping

LOAD Country,

     Region

FROM ....;

FactTable:

LOAD Country,

     ApplyMap('MappingTable', Country, 'N/A') as Region,

     ....

FROM ....;

[soniasweety]

thank you  sunny,

but I am unable to get the desired output  can u attach small sample with 10 or 15 records?  by that I can map with my data?

[sunny_talwar]

Something like this

MappingTable:

Mapping

LOAD Code,

    Destination

FROM

[..\..\Downloads\codes.xlsx]

(ooxml, embedded labels, table is CountryCodes);

Fact:

LOAD Co,

ApplyMap('MappingTable', Co, 'N/A') as Region

FROM

[..\..\Downloads\codes.xlsx]

(ooxml, embedded labels, table is MI);

[soniasweety]

Thanks sunny,

I don't have qlikview license but I got the region column. But  here I my requirement is,

I need to show pie chart  count(region) of both BB&MI   how can I write both mapping tables in one?

[sunny_talwar]

Are these both in two different tables? Do you concatenate these two tables into one? Not sure how your data model looks like?