topic How to map the data in QlikView

How to map the data

Mon, 19 Mar 2012 08:14:22 GMT

Hello,

I've the data in my qvd file like this..

A	B	C
1	2	1
2	2	1
3	2	1
4	2	1
1	1	1
2	1	1
3	1	1
4	1	1

Using Mapping concept i want to generate the data as shown below how can i generate it.

A	B	C	ABCD
1	2	1	8
2	2	1	6
3	2	1	4
4	2	1	2
1	1	1	7
2	1	1	5
3	1	1	3
4	1	1	1

What is the code for this concept?

How to map the data

jvitantonio — Mon, 19 Mar 2012 08:16:10 GMT

Can you explain the logic behind this tables?

How to map the data

martinpohl — Mon, 19 Mar 2012 08:18:04 GMT

Hello Jacq,

first step mapping table

Mappingtab:

mapping load

A&B&C as Key,

D from source;

then in the second table

load *,

applymap('Mappingtab',A&B&C,0) as ABCD

from source;

Regards

How to map the data

Mon, 19 Mar 2012 08:21:46 GMT

If you observe the first table for each combination i'm assigning one value in second table.

For eg:

The data of the columns A,B,C -> ABCD

1,2,1 ->8

2,2,1 ->6

3,2,1 ->4

4,2,1 ->2

How to map the data

Mon, 19 Mar 2012 09:04:57 GMT

I got the solution for this..

Temp:

Load * Inline [

A,B,C,ABCD

'1','2','1','8'

'2','2','1','6'

'3','2','1','4'

'4','2','1','2'

'1','1','1','7'

'2','1','1','5'

'3','1','1','3'

'4','1','1','1'

];

Map1:

Mapping

LOAD

A & B & C as key,

ABCD

Resident Temp;

DROP Table Temp;

T2:

LOAD

B, C,ApplyMap('Map1',A & B & C,Null()) as ABCD

FROM

QVD\TFile.qvd

(qvd);