Keep data

[#1]

I have an sql, which takes data only for the actual date. I would like to run it everyday keeping the datas of the days before. How can i do it?

[SunilChauhan]

would you like to store data of 1 day back

[#3]

Actually i would like to store all the past data.

[Sokkorn]

Hi,

Try to use Incremental Load that this one can keep your historical data.

Regards,

Sokkorn

[#5]

How does it work?

Thanks,

Javier

[its_anandrjs]

Hi,

Use some thing in your load script.

Load Incremental( StartDate - Enddate,'DD')

Rgds

Anand

[SunilChauhan]

see the attached pdf

hope this heelps

[its_anandrjs]

Hi,

Follow this link

http://community.qlik.com/docs/DOC-1870

It is a best practice

Rgds

Anand

[Sokkorn]

Hi Javier,

In the community have a lot of incremental load example. The purpose of incremental load is keep historical data. This one can be call Data Warehouse. The question is How does it work?

Load full for the first time (Ex. from 01.09.2011 to 29.09.2011) then store into QVD file.

After that the new data in 30.09.2011 come, then we load new data only for the date 30.09.2011 and concatenate with the previouse data.

Regards,

Sokkorn

[#10]

But the data i want to keep are the ones which are showed in QLikview, i don't generate any table. The problem is my sql only takes the data for the actual date and i want to add them. I see all your helps are for taking only the actual data of some table.