QVD Period

[pgalvezt]

Hello, Im connected by OLE DB on many databases (Differents folders with many clients and months) to get all thouse connections Im using LOAD *, 'Site' as Source; LOAD *, 'Site1' as Source;LOAD *, 'Site3' as Source; and so on for each connection. Finally I Stored them as BasesTarjetas. Now Im Trying to generate qvds by months because the current qvd is too heavy. Reading in the forum I found this:

http://community.qlik.com/message/200824#200824

I tried to do the same thing with Resident table but it QVD.

Temp:
LOAD  Distinct Month(TDCORTE2) AS MonthName
resident BasesTarjetas;

LET vCount=NoOfRows('Temp');
FOR i=0 to $(vCount)
LET vMonth = Peek('MonthName',$(i),'Temp');

MonthWise:
LOAD *
Resident BasesTarjetas
Where Month(TDCORTE2) = '$(vMonth)';

STORE MonthWise into Month\$(vMonth).qvd;

DROP Table MonthWise;

Next
DROP Table Temp;

!Warning Message Table not found!

Thank you!

[pgalvezt]

Done!!

Look I want to share this with you maybe it helps you in the future:

Temp:
LOAD  Distinct Num(Year(Date(PERIOD,'MMM-YY'))) & Num(Month(Date(PERIOD,'MMM-YY')),'00')  AS Period
resident BasesTarjetas;

LET vCount=NoOfRows('Temp');
FOR i=0 to $(vCount)
LET vCarga = Peek('Period',$(i),'Temp');

Tarjetas:
NoConcatenate
LOAD *
Resident BasesTarjetas
Where Num(Year(Date(PERIODO,'MMM-YY'))) & Num(Month(Date(PERIODO,'MMM-YY')),'00') = '$(vCarga)';

STORE Tarjetas into $(PathProdQvd)Tarjetas$(vCarga).qvd;

DROP Table Tarjetas;

Next
DROP Table Temp;

Results Tarjetas201204.qvd Tarjetas201205 so on.

Many Thanks.