How to apply Incremental Load on QVW file (Not on QVD)?

[#1]

Hi,

I want to apply an incremental load on qvw file not on qvd.

I had already applied an Incremental load on qvd.

When I reload my QVW file for first time it should contains the latest 25 days data and then on the next day when i again reload that qvw file it should delete the first day data and append only latest 1 day data.

Eg:- When I reload QVW for first time it has data from 05/12/2013 to 30/12/2013.

When I reload that QVW file on 31/12/2013, So it should delete the data of 04/12/2013 and append only one day data i.e, of 31/12/2013.

Is this Possible??????

[#2]

Hi Sunil,

But if i will do the above changes it will fetch the full one month data...

I just want to append only the latest data with the old data...(Incremental Load)

[sunilkumarqv · Accepted solution]

Example your date  are like below

Set DateFormate='DD/MM/YYY'

Date

1/1/2014

2/1/2014

3/1/2014

then

where  Date> '2/1/2014' and  Date<='3/1/2014 ';

you will get appended only 3/1/2014 and make sure that Dateformate  defined should match to database date format

[Anonymous]

Hi Piyushkumar,

By usihg this condition u will get the last one day of data from updated table where date >= $(vVar2 ) and date  < $(vVar2 ).

[#5]

If you take the Max data date as FromDate and Today() as ToDate, you would get the data for latest one day.

The only thing left is to remove the data from the Minimum Day so as to have only 30 day data. For that you can use where clause with FromDate= Min Date + (MaxDate-Today()) and ToDate as Today()

Somthing like this may be.

Thanks

[#6]

Thanks Guyz

[vikasmahajan]

Go through Incremental Load this discussion.

Vikas