Previous Date in the Script

Anonymous — Tue, 16 Apr 2013 17:28:13 GMT

Hi ,

We have base data coming like below:

We want to add another computed column which gives ous previous business date.

Please help me how can we compute Prev_Business_Date column in the load script?.

Thanks

Dasu.G

Re: Previous Date in the Script

Gysbert_Wassenaar — Tue, 16 Apr 2013 17:29:59 GMT

Load

...some fields...

if(previous(Business_Date)<>Business_Date, previous(Business_Date), peek(Prev_Business_Date)) as Prev_Business_Date,

...some more fields...

from ...mysource...;

Note: your table needs to be ordered by Calendar_Date or you get funny results.