Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

arethaking
Contributor 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
Honored Contributor II

Re: How to create Mapping load?

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
YoussefBelloum
Esteemed Contributor

Re: How to create Mapping load?

Partner
Partner

Re: How to create Mapping load?

Hi Aretha,

Please refer below thread.

quick applymap example

Thanks,

Arvind Patil

Partner
Partner

Re: How to create Mapping load?

balabhaskarqlik
Honored Contributor

Re: How to create Mapping load?

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
Honored Contributor II

Re: How to create Mapping load?

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

Highlighted
pintucs20
New Contributor III

Re: How to create Mapping load?

Can you share Table, please??