Problem in Dummy field

Thu, 13 Oct 2011 07:50:27 GMT

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 (qvd);

LEFT JOIN

LOAD Code AS ProductID,

AppRefNo,

[New Group] AS Product

FROM

(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

topic Problem in Dummy field in QlikView