Regarding last record

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have the data in database..it contains some future dates..like

[YEAR-WEEK]

2017-01

2017-02

2017-03

2017-04

2017-05

2017-06

2017-07

2017-16

2017-31

2017-32

2017-50

when i am applying incremental load ..taking the filed for [year week]..by using peek function

LET vlastyearweek=Peek('[YEAR-WEEK]',-1,'bi_sort');

The variable was not taking any value and it was no seen also...but the last value is 2017-50(means no data for that).

Here how can i create the variable for present [YEAR-WEEK] as 2017-08 ..and

based on the current year variable ..how can we compare to 2017-50...how we can apply incremental load to it...please explain..??

your help should be appreciable....

Re: Regarding last record

m_woolf — Thu, 23 Feb 2017 18:54:32 GMT

Try this:

LET vlastyearweek=Peek('YEAR-WEEK',-1,'bi_sort');