Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
dhanavindhan
Creator
Creator

QVD Genaration Issue

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

1 Solution

Accepted Solutions
andrey_krylov
Specialist
Specialist

 

try to add (qvd) to this string.

      LOAD * from Operationdelay.qvd (qvd);

View solution in original post

2 Replies
andrey_krylov
Specialist
Specialist

 

try to add (qvd) to this string.

      LOAD * from Operationdelay.qvd (qvd);

dhanavindhan
Creator
Creator
Author

Tnx Andrey, wat a silly mistake i made