topic Re: Help in Mapping in QlikView

Help in Mapping

vikasshana — Mon, 15 Oct 2018 14:06:19 GMT

Hi,

I'm using the below simple code to work on Mapping and ApplyMap.

CustomerTable:

Mapping

Load * Inline

[

CustomerID,ID,Test

1,A,AA

2,B,BB

3,C,CC

4,D,DD

5,E,EE

6,F,FF

7,G,GG

8,H,HH

9,I,II

];

Sales:

Load *

,ApplyMap('CustomerTable', CustomerID) as CustomerCountry,

ApplyMap('CustomerTable', CustomerID) as Test

Inline

[

CustomerID

];

But it is throwing an error 'Generic tables must contain at least 3 fields'. I would like to see output like below.

CustomerCountry	CustomerID	TestID
A	1	AA
B	2	BB
C	3	CC
D	4	DD
E	5	EE

It is giving me the output which I'm expecting if i create a new test table and Mapping that test table to ApplyMap table but i don't want the Test Table.

Regards,

Bharath Vikas

Re: Help in Mapping

ali_hijazi — Mon, 15 Oct 2018 14:16:59 GMT

Mapping tables should only have 2 columns; in your case you should create two mapping tables one for country and one for test ID

A mapping table consists of two columns, the first containing comparison values and the second containing the desired mapping values. Mapping tables are stored temporarily in memory and dropped automatically after script execution.

refer to the below link for more details on mapping tables in Qlik

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ScriptPrefixes/Mapping.htm

Re: Help in Mapping

snehamahaveer — Mon, 15 Oct 2018 15:36:19 GMT

Hello Vikas,

The below code will help with your query. The Mapping load as mentioned above should only have 2 columns.

CustomerTable:

Mapping

Load * Inline

[

CustomerID,ID

1,A

2,B

3,C

4,D

5,E

6,F

7,G

8,H

9,I

];

Sales:

Load

ApplyMap('CustomerTable', CustomerID) as CustomerCountry,

ApplyMap('CustomerTable', CustomerID)&ApplyMap('CustomerTable', CustomerID) as Test;

Load * Inline

[CustomerID

];

Regards,

Sneha