topic Re: Map ... using : in QlikView

Map ... using :

soloeeeoff — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I tried <Map..Using> keyword as

tab1:
LOAD No,
Dept
FROM

(ooxml, embedded labels, table is Sheet1);

map1:
Mapping
LOAD m_key,
m_Value
FROM

(ooxml, embedded labels, table is Map);

Map Dept using map1;

But I could not understand what difference it makes ..

Please explain me..

Re: Map ... using :

Anonymous — Fri, 16 Sep 2016 16:49:18 GMT

I think you did not get concept of Mapping.. It replaces values of field you want to have in place of.

Think of a data model where you have a lot of Dept fields which values you want to rename in the whole data model. You would either use as many ApplyMap() functions as fields you want to change, or use MAP Field USING after the MAPPING LOAD.

Re: Map ... using :

Anil_Babu_Samineni — Fri, 16 Sep 2016 16:51:24 GMT

Perhaps This

tab1:
Mapping LOAD No,
Dept
FROM

(ooxml, embedded labels, table is Sheet1);

map1:
LOAD m_key,
m_Value
FROM

(ooxml, embedded labels, table is Map);

Map Dept using map1;

Applymap('tab1',Dept,'UnknownKey')

Re: Map ... using :

swuehl — Fri, 16 Sep 2016 18:02:08 GMT

I think the order of your statements should be

1) Create your mapping table using MAPPING LOAD prefix

2) MAP Field. USING Map;

3) LOAD Field FROM ....;