Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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....
Try this:
LET vlastyearweek=Peek('YEAR-WEEK',-1,'bi_sort');