QVD Genaration Issue

dhanavindhan — Thu, 23 Aug 2018 11:13:07 GMT

Hi,

I have a problem when i am reloading my QVD for getting data from DB.

I have 2 script both combined by "CONCATENATE".

Script1:

Operationdelay:

SQL Select ContainerNo,EquipmentType,containerstatus,bookNo,VesselCode,Voyage,ServiceCode,Bound,

Wt,CargoType,OprType,status,nxtStatus,agencyCode,datecr,actdate,mode,year(datecr) as DL_year,

month(datecr) as DL_Month,dbo.ISOweek_SunToSat(datecr) as DL_Weekno from operationdetail

where datecr >= '2016-01-01';

Store Operationdelay into Operationdelay.qvd(qvd);

drop table Operationdelay;

Note: From above script i am pulling data from 2016.

My QVD size after reload is around (98 MB).

Script2:

Operationdelay:

Load * from Operationdelay.qvd;

Concatenate

SQL Select ContainerNo,EquipmentType,containerstatus,bookNo,VesselCode,Voyage,ServiceCode,Bound,

Wt,CargoType,OprType,status,nxtStatus,agencyCode,datecr,actdate,mode,year(datecr) as DL_year,

month(datecr) as DL_Month,dbo.ISOweek_SunToSat(datecr) as DL_Weekno from operationdetail;

Store Operationdelay into Operationdelay.qvd(qvd);

drop table Operationdelay;

I am running this script with different DB and getting some more data from that DB. I am concatenating first script with this one. The issue was when run this second script it reloads only limited data and the QVD size becomes (Around 11 MB). How is it possible whe we use "concatenate" in both DB i have same table with same column name i checked twice. Pls help me to fix this problem.

Regards,

Dhana R

Re: QVD Genaration Issue

andrey_krylov — Thu, 23 Aug 2018 11:37:50 GMT

try to add (qvd) to this string.

LOAD * from Operationdelay.qvd (qvd);

Re: QVD Genaration Issue

dhanavindhan — Thu, 23 Aug 2018 12:25:24 GMT

Tnx Andrey, wat a silly mistake i made

topic Re: QVD Genaration Issue in QlikView

QVD Genaration Issue

Re: QVD Genaration Issue

Re: QVD Genaration Issue