How to create Mapping load?

[arethaking]

Hi All,

I am new to Qlikview

How to create Mapping load?

please help.

[YoussefBelloum]

Hi,

https://community.qlik.com/search.jspa?q=mapping%20load*&facet=content

[arvind_patil]

Hi Aretha,

Please refer below thread.

quick applymap example

Thanks,

Arvind Patil

[PabloTrevisan]

Hi Aretha !
Welcome to Qlik world !

Take a look in this link:

https://help.qlik.com/pt-BR/qlikview/November2017/Subsystems/Client/Content/Scripting/ScriptPrefixes...

[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 · Accepted solution]

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]

Can you share Table, please??