no data replace 0

[#1]

if there is no data end set the value to zero.I need the hellp pn this for a calculation.

if net balance dnt ave data then we should get 0 so tha in comupaion of

balance-net balance we get, blance-0=balance

Regards,

Prajna

[#2]

Hi Prajna,

Yes . That is what I proposed. Alias_ID will be same for all IDs So that all the IDs are having all the dates(As good as Cartisian Product if you want to relate to oracle/SQL).

You can alter table by just using

Load

*,

'111' AS Alias_ID

Resident Calander;

One more thing associate Transation with Calander instead of Balance with Calander

I'll also try this solution and try sharing qvw.

Thanks & Regards

Suhas Gupta

[#3]

Okay

actually its getting loop... calender gets associated wiith balance through alias id rite?

transaction and calender with date.

balance and transaction with id

so loop is been created..

Regards,

Prajna

[#4]

Hey Prajna,

PFA solution. Please tell if this what you were looking for.

Thanks & Regards

Suhas Gupta