QVD Period Error

pgalvezt — Tue, 14 Aug 2012 21:38:38 GMT

Hi. I've tried to separate my multibases by QVD Period. Im connecting by from ODBC to Many bases: The bases has the same fields

so Im using aLoad sentence Like this: The first Connection = Abr 2012, The Second Connection May 2012 and so on,

Tables:

OLEDB CONNECT TO [Provider=VFPOLEDB.1;Data Source=e:\modelos\solventa\tarjetas de credito\datos externos\bases_tc\2012\05_mayo\83 - bata;Mode=Share Deny None;Extended Properties="";User ID="";Mask Password=False;Cache Authentication=False;Encrypt Password=False;Collating Sequence=MACHINE;DSN="";DELETED=True;CODEPAGE=1252;MVCOUNT=16384;ENGINEBEHAVIOR=90;TABLEVALIDATE=3;REFRESH=5;VARCHARMAPPING=False;ANSI=True;REPROCESS=5];
LOAD *, 'Site1' as Source;
LOAD
Field1,

Field2

SQL SELECT *
FROM Table1
Where Field1 = 1;

Field2

SQL SELECT *
FROM Table1
Where Field1 = 1;

and so on...

Store Tables Into $(PathProdQvd)Tables.qvd;

So I can save all the register in junst one single table.

Now I want to separe this tables and load singles Qvds by period:

Temp:
LOAD Distinct Num(Year(Date(Field2,'MMM-YY'))) & Num(Month(Date(Field2,'MMM-YY')),'00') AS Load_Period
resident Tables;

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

V1:
NoConcatenate
LOAD *
Resident TablesWhere Num(Year(Date(Field2,'MMM-YY'))) & Num(Month(Date(Field2,'MMM-YY')),'00') = '$(vCarga)';

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

DROP Table V1;

Next
DROP Table Temp;

I Noticed that my QVD May has ABR and MAY Together. How can I separate the months by QVDs.

My Actual QVD is V1201204 (But Show Abr and may)

Thank you

topic QVD Period Error in QlikView

QVD Period Error