0 Replies Latest reply: Oct 13, 2011 3:50 AM by Gaurav Choudhary RSS

    Problem in Dummy field

      I found a problem ,when i join the 2 table then some of the data being LOST .

      But when i used dummy field as shown below then i got the exact figure.

      plz help me to understand why the data was lost and HOW is it work(Key1 and Key2)????

       

       

       

       

      LoanInfo:

      LOAD AccountID AS AcctNo,

           ApplicationID AS AppRefNo,

           DisbursedOn AS DisbursalDate,

           'LMDummy' AS Key1                                       /* What's the use of this?*/

      FROM [D:\QV project\table1.qvd] (qvd);

      LEFT JOIN

      LOAD Code AS ProductID,

                AppRefNo,

                [New Group] AS Product

      FROM [D:\QV project\table2.xlsx]

      (ooxml, embedded labels, table is Sheet1);

       

      Delinquency:

      LOAD (NUM(YEAR(MonthEnd))-1)*12+NUM(MONTH(MonthEnd)) AS MonthEndID,

           DATE(MonthEnd) AS MonthEnd,

           AcctNo,

           POS,

           DPD,

           'Dummy' AS Key2

      FROM D:\QV project\table3.qvd(qvd);

      JOIN

      LOAD AcctNo

      RESIDENT LoanInfo; 

       

       

       

       

      /*************************************************************************/

       

       

      Need your help to understand.....

       

      Thanks & Regards
      GC