topic Want to Solve the Query using Mapping Load in QlikView

Want to Solve the Query using Mapping Load

Tue, 20 Apr 2010 07:18:31 GMT

Hi,

Please help my query using Mapping Load instead of using JOIN, as i am not much aware of mapping load

I have 2 table

Table1:

IR_DPD	no of Accts
0 - 29 DPD	24,443
30 - 59 DPD	11,770
60 - 89 DPD	8,426
90 - 119 DPD	8,001
120 - 149 DPD	1
180 - 209 DPD	1
240 - 269 DPD	1
390 - 419 DPD	2
Current	317,066
GWO	3,938
NCL	68,928

Table 2:

IR_DPD	FullPOS	POS
0 - 29 DPD	631,626,108	1
30 - 59 DPD	303,230,518	2
60 - 89 DPD	215,404,729	3
90 - 119 DPD	203,847,230	4
120 - 149 DPD	320,946	5
180 - 209 DPD	376,862	6
240 - 269 DPD	914,550	7
390 - 419 DPD	497,457	8
Current	12,394,438,430	9

Now i want the Table 2 data should join into Table1(using mapping load). and the output i should get is:

IR_DPD	no of Accts	FullPOS	POS
0 - 29 DPD	24,443	631,626,108	1
30 - 59 DPD	11,770	303,230,518	2
60 - 89 DPD	8,426	215,404,729	3
90 - 119 DPD	8,001	203,847,230	4
120 - 149 DPD	1	320,946	5
180 - 209 DPD	1	376,862	6
240 - 269 DPD	1	914,550	7
390 - 419 DPD	2	497,457	8
Current	317,066	12,394,438,430	9
GWO	3,938	-	-
NCL	68,928	-	-

Thanks

Want to Solve the Query using Mapping Load

Tue, 20 Apr 2010 07:38:28 GMT

Hi,

Your load script should be as below.

Table1:

Mapping Load IR_DPD,

"no of Accts"

from Table1;

Table2:

Load IR_DPD,

FullPOS,

POS,

Applymap('Table1',IR_DPD,null()) as "no of Accts"

From Table2;

Hope this will help you.

- Sridhar

Want to Solve the Query using Mapping Load

Tue, 20 Apr 2010 07:54:36 GMT

Thanks Sridar for the reply..

But this couldnt help me and get the output as i want.. I want from Table 2 there are 2 columns (FullPOS,POS) should jon in to Table 1. Because in table 1 the 1st unique coulmn (IR_DPD) is more then 2nd one..

please help me with other solution..

Want to Solve the Query using Mapping Load

sunil2288 — Tue, 20 Apr 2010 11:14:46 GMT

HI Ankit

It does n't matter ...just Load the excel sheet and perform the mapping as in the second table

Applymap('Table1',IR_DPD,null()) as "no of Accts"

in the second table as a colomn

cheers,

Regards,

Sunil

Want to Solve the Query using Mapping Load

Wed, 21 Apr 2010 06:28:32 GMT

Its not solving My Problem.. U mean to say that we cant join 2 columns in to one table using Mapping Load.

Want to Solve the Query using Mapping Load

sunil2288 — Wed, 21 Apr 2010 06:39:54 GMT

HI Ankit

Am not clear about your doubt.. In accordance with your rquirement that u hav mentioned in the prevoius posts Your table should hav 4 columns and that's the solution i hav post...

Want to Solve the Query using Mapping Load

Wed, 21 Apr 2010 07:38:24 GMT

HI Sunil,

U can Compare my Output with Your output u will find that the DPD's are repeating (eg. 0-29 DPD,60-89DPD..) and the ( -) are occuring.

See basicaly its solves my problem if i have Table1 as base table and do left join(Table 1) and join table 2 with the base table. but i need to solve using Mapping Load.. So is it possible i can write 2 apply Map for puuting 2 columns (FullPOS, POS) in Table 1..

Hope you got some idea

Want to Solve the Query using Mapping Load

Wed, 21 Apr 2010 13:38:07 GMT

Please Can Any One solve my query???