Load only the last day's data

[linoyel]

Hi!

I have a very heavy qvd document that runs once an hour for about 20 mins, which brings data for several years.

Some of the loads in the document are incremental, and some are full.

My task is to create the same document but it will have to show only the last 24 hours and be reloaded every 10 mins.

What's the way to do this?

Plus what's the way to do this without interrupting the every-hour process (cause the exact same tables will be used in 2 documents)?

[linoyel]

So, as I understand, I should binary upload the main document into the small one, so the data I need from the small doc will be updated every 20 mins?

[tresesco]

Even I meant so.

[linoyel]

Cool

[linoyel]

It gets stuck after the reload...

Maybe it's because the small document is actually the exact copy (just with less data) of the main one?

All field names are the same.. maybe that's what is causing the problem?

In binary load should I make 2 completely different data sets?