How to Calculate the Values...

[alvinford]

Hi ,

I have 2 QVDs Temp and Temp2. Monthly Amount is in my Temp2 Table.  My requirement is, For  the Key values found in the Temp table the MonthlyAmount has to be calculated from Termstart  to TermEnd Date (i.e to overwrite the Startdate and EndDate values in the Temp2 with TermstartDate and TermEndDate ) The MonthlyAmount for Key Value in the Temp2  remains same..

Please find the attached QVDs.

Please guide me to achieve this ..

Temp:

LOAD Key,

     TermEndDate,

     TermStartDate

FROM

Temp.Qvd

(qvd);


Temp2:

LOAD Key,

     BuildingID,

     UnitID,

     ChargeTypeID,

     StartDate,

     EndDate,

     MonthlyAmount

FROM

Temp2.Qvd

(qvd);

Regards,

Alvin.

[sivarajs]

Rename StartDate asTermStartDate and EndDate as TermEndDate

Now both the table is connected . You can use the expression to calculate monthly amount