Problems Regarding Incremental load with future data

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

here one issue i am facing ..

our database table contains the field year, week,....etc

i am clubbed the both data as year-week.

but in database it contains wrong dates as future dates but no values to them

YEAR_WEEK

2017-1

2017-2

2017-3

2017-4

2017-5

2017-6

2017-12

2017-32

2017-33,

2017-50

while i am applying incremental load,

while taking last [year-week] to the variable it takes last date..means 2017-50

how can i get the present year week ?

how can i apply the incremental load ?

your answers would be so helpful...Thank you

Re: Problems Regarding Incremental load with future data

Anil_Babu_Samineni — Wed, 22 Feb 2017 16:16:43 GMT

When you talk about Present Week Year you should required to use Today() function even if you have Forecast data

Year(Today()) & '-' & 'Week(Today())

QlikView Incremental Load