topic Re: How to create Mapping load? in QlikView

How to create Mapping load?

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

Hi All,

I am new to Qlikview

How to create Mapping load?

please help.

Re: How to create Mapping load?

YoussefBelloum — Thu, 02 Aug 2018 12:05:19 GMT

Hi,

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

Re: How to create Mapping load?

arvind_patil — Thu, 02 Aug 2018 12:07:36 GMT

Hi Aretha,

Please refer below thread.

quick applymap example

Thanks,

Arvind Patil

Re: How to create Mapping load?

PabloTrevisan — Thu, 02 Aug 2018 12:17:38 GMT

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/Mapping.htm

Re: How to create Mapping load?

BalaBhaskar_Qlik — Thu, 02 Aug 2018 14:19:31 GMT

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);

Re: How to create Mapping load?

qlikviewwizard — Fri, 03 Aug 2018 04:15:47 GMT

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?

Re: How to create Mapping load?

pintucs20 — Fri, 03 Aug 2018 07:38:35 GMT

Can you share Table, please??