3 Replies Latest reply: Apr 19, 2010 2:20 AM by AnkitModi RSS

    Pls Solve my Query using Mapping Load

    AnkitModi

      HI,

      As ia m new in to Qlikview and using 8.5. i have stuck into a query and want o solve using Mapping Load..

      I have 2 tables

      Table1:

       

      IR_DPDFullPOS
      0 - 29 DPD631,626,108
      30 - 59 DPD303,230,518
      60 - 89 DPD215,404,729
      90 - 119 DPD203,847,230
      120 - 149 DPD320,946
      180 - 209 DPD376,862
      240 - 269 DPD914,550
      390 - 419 DPD497,457
      Current12,394,438,430
      GWO94,896,352
      NCL1,774,643,985
      Total15,620,197,167


       

      Table 2:

       

      IR_DPDno of Accts
      0 - 29 DPD24,443
      30 - 59 DPD11,770
      60 - 89 DPD8,426
      90 - 119 DPD8,001
      120 - 149 DPD1
      180 - 209 DPD1
      240 - 269 DPD1
      390 - 419 DPD2
      Current317,066
      GWO3,938
      NCL68,928
      Total442,577


      Now, instead of using JOIN i want to use MAPPING LOAD to get the Output as:

       

      IR_DPDFullPOSno of Accts
      0 - 29 DPD631,626,10824,443
      30 - 59 DPD303,230,51811,770
      60 - 89 DPD215,404,7298,426
      90 - 119 DPD203,847,2308,001
      120 - 149 DPD320,9461
      180 - 209 DPD376,8621
      240 - 269 DPD914,5501
      390 - 419 DPD497,4572
      Current12,394,438,430317,066
      GWO94,896,3523,938
      NCL1,774,643,98568,928
      Total15,620,197,167442,577


       

      PLease any of can suggest me how to solve it.

      Thanks.