topic Re: Multiple mappings to one field in QlikView

Multiple mappings to one field

paul_ripley — Mon, 13 Jun 2016 15:40:31 GMT

Hello

I have 2 fields, costc and geography, that i would like to map to a new field 'region'

The problem that I have is that the field 'region' has to be unique in the load. How can I apply to the 2 mappings to the one field 'region'. Is this possible?

Many thanks

Paul

map_region:

mapping

LOAD

costc,

region

FROM

[..\..\01_SOURCE_DATA\XLS\DM\europeorus.xlsx]

(ooxml, embedded labels, table is Sheet1);

map_geography:

mapping

LOAD

geography,

region

FROM

[..\..\01_SOURCE_DATA\XLS\DM\dmregionkpi.xlsx]

(ooxml, embedded labels, table is Sheet1);

DM:

LOAD

applymap ('map_geography',geography,'NOT_FOUND') as region_desc,

applymap ('map_region',costc,'NOT_FOUND') as region_desc,

Re: Multiple mappings to one field

sunny_talwar — Mon, 13 Jun 2016 15:49:08 GMT

May be like this:

map_region:

mapping

LOAD

costc,

region

FROM

[..\..\01_SOURCE_DATA\XLS\DM\europeorus.xlsx]

(ooxml, embedded labels, table is Sheet1);

map_geography:

mapping

LOAD

geography,

region

FROM

[..\..\01_SOURCE_DATA\XLS\DM\dmregionkpi.xlsx]

(ooxml, embedded labels, table is Sheet1);

DM:

LOAD

ApplyMap('map_geography', geography, ApplyMap('map_region', costc, 'NOT_FOUND')) as region_desc,

Re: Multiple mappings to one field

paul_ripley — Mon, 13 Jun 2016 16:24:45 GMT

Hi Sunny

Thanks a lot for your help

Paul