Hist Qvd

[hafaneh]

Hello, 
can i store a qvd in a qvd like this : 

LOAD
DOCNO,
TRXH_LOC_CODE,
FROM [lib://DataFiles/ALLHistory.qvd]
(qvd);

Concatenate

LOAD
DOCNO,
TRXH_LOC_CODE,
FROM [lib://O/xxx_Daily3Days.qvd]
(qvd);

STORE xxx_Daily3Days INTO 'lib://DataFiles/3daysDailySales.qvd' (qvd);
drop Table xxx_Daily3Days;

i have a qvd that i take from the server that have only 3 days daily data, 

i want to make the qvd for the history on the cloud. 

[PrashantSangle]

yes, you can.. are you getting any error?

[hafaneh]

hello,
yeah : 

The following error occurred:

Table 'xxx_Daily3Days' not found

The error occurred here:

STORE xxx_Daily3Days INTO 'lib://DataFiles/3daysDailySales.qvd' (qvd)

[PrashantSangle]

do you have that qvd in that location??

[PrashantSangle]

you are getting error in below part of script.

Just check

[hafaneh]

@PrashantSangle 

yes yes im getting this qvd from their its on the onedrive so i take it from their 

[PrashantSangle · Accepted solution]

try below

historicalQVD:

LOAD
DOCNO,
TRXH_LOC_CODE,
FROM [lib://DataFiles/ALLHistory.qvd]
(qvd);

Concatenate

LOAD
DOCNO,
TRXH_LOC_CODE,
FROM [lib://O/xxx_Daily3Days.qvd]
(qvd);

STORE historicalQVD INTO 'lib://DataFiles/3daysDailySales.qvd' (qvd);
drop Table xxx_Daily3Days;

Regards,

Prashant Sangle

[HAmzehAF]

@PrashantSangle 

hello can you tell how to fix this 

Started loading data

xxx_Daily3DaysNEW << xxx_Daily3DaysNEW (QVD (row-based) optimized)

Lines fetched: 1,418,274

xxx_Daily3DaysNEW << xxx_Daily3Days (QVD (row-based) optimized)

Lines fetched: 2,127,411

when i load the data i get duplicate