How to save multiple qvds into one qvd?

[siva_boggarapu]

Hi there,

I have 10 qvd files. I need to make them as single qvd file. Could you please any one describe this?

[Miguel_Angel_Baeyens]

Hello Siva,

That sounds strange. If you concatenate only two or three files manually as specified here, is the file still empty?

Regards

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

[aarohipatel]

Hi Miguel,

I have multiple qvd;s for multiple years in one folder. What I want to do is store 2015* qvd's into one and 2016* qvd's into another. I want to store these qvd's in the same folder. Did the following but when doing this from one qvw, reload failed with an

Error: Table 'Test2016' not found

// This loads all files in one table 
Test2015:  
LOAD *  
FROM [..\..\_Test\qvd\TEST_2015*.qvd] (qvd); 

// This stores all previous QVDs in one 
STORE Test2015 INTO [..\..\_Test\qvd\TEST_2015.qvd];


// This loads all files in one table 
Test2016:  
LOAD *  
FROM [..\..\_Test\qvd\TEST_2016*.qvd] (qvd); 

// This stores all previous QVDs in one 
STORE Test2016 INTO [..\..\_Test\qvd\TEST_2016.qvd]; 

Please advise.

Thanks

[aarohipatel]

Hello, the solution for this is, we have to drop table 'Test2015' before loading Test2016 table.

[burcinyazici]

I faced similar problem. I'm saving qvd's per day x10 reports. So there's huge number of files. I'm concerning about file count. Is it an unnecessary worry?

[rajareddyjkl]

i  try  same  logic  on my  tables it  will filed 

it  showing 

-129 =

2018-08-02 15:18:56      Execution Failed