Limit load into QVD

[#1]

How can I limit the number of weeks into a QVD? For example, I have over 40 weeks of sales history data in a table but I only want to load the most recent 10 weeks of data.

How can I do this?

[jaimeaguilar]

Hi,

you can filter weeks taking as reference you main date field:

YOUR_TABLE:

LOAD *

from table.qvd(qvd)

where week(Date) > Week(today())-10 and Year(Date) = Year(today());

so you'll get current week and the 9 before,

regards