Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
arethaking
Creator II
Creator II

How to create Mapping load?

Hi All,

I am new to Qlikview

How to create Mapping load?

please help.

1 Solution

Accepted Solutions
qlikviewwizard
Master II
Master II

Please check this simple example.

//Mapping Table

CustomerTable:
Mapping Load * Inline
[
CustomerID, Country
A, Germany
B, France
C, Italy
D, Poland
E, Spain
Z, UK
]
;

Sales:
Load *,
ApplyMap('CustomerTable', CustomerID, 'Unknown') as CustomerCountry

Inline
[
CustomerID, Month, Sales
A, Jan, 100
B, Jan, 200
C, Jan, 300
D, Feb, 150
E, Mar, 200
F, Apr, 100
A, May, 140
D, May, 80
E, May, 100
F, Jun, 150
]
;

Credit : its.anandrjs

what is mapping load and apply map?

View solution in original post

6 Replies
arvind_patil
Partner - Specialist III
Partner - Specialist III

Hi Aretha,

Please refer below thread.

quick applymap example

Thanks,

Arvind Patil

PabloTrevisan
Partner - Creator II
Partner - Creator II

balabhaskarqlik

Like this:

MAP:

Mapping LOAD

[PSA Project pse Project ID],

[HOLD Closure date2] 

FROM

[$(QVD_Path)\GSD_HOLDClosuredate2.qvd](qvd);

HOLD:

LOAD

     [PSA Project pse Project ID],

     [HOLD Closure date],

     Applymap('MAP', [PSA Project pse Project ID], ApplyMap('MAP',[HOLD Closure date2],Null()) as T

FROM

[$(QVD_Path)\GSD_HOLDClosuredate.qvd](qvd);

qlikviewwizard
Master II
Master II

Please check this simple example.

//Mapping Table

CustomerTable:
Mapping Load * Inline
[
CustomerID, Country
A, Germany
B, France
C, Italy
D, Poland
E, Spain
Z, UK
]
;

Sales:
Load *,
ApplyMap('CustomerTable', CustomerID, 'Unknown') as CustomerCountry

Inline
[
CustomerID, Month, Sales
A, Jan, 100
B, Jan, 200
C, Jan, 300
D, Feb, 150
E, Mar, 200
F, Apr, 100
A, May, 140
D, May, 80
E, May, 100
F, Jun, 150
]
;

Credit : its.anandrjs

what is mapping load and apply map?

pintucs20
Contributor III
Contributor III

Can you share Table, please??