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: 
siva_boggarapu
Creator II
Creator II

How to save multiple qvds into one qvd?

Hi there,

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

24 Replies
siva_boggarapu
Creator II
Creator II
Author

Hi Miguel,

Thank you

dkbhatt51
Contributor III
Contributor III

Sridhar wrote  "Moreover if the Qvd`s has different field names, then my code will create a QVD only for the 1st loaded table and it will not create a QVD for subsequent loaded tables."

It is not necessary for all qvd files to have same fields. You can load fields with different names by using 'cocatenate load' and then store the table to 'Final.qvd'. Something like:

Tab1:

Load * from file1.qvd;

cocatenate load * from file2.qvd;

cocatenate load * from file3.qvd;

store * from Tab1 into Fianl.qvd

Darshan

Miguel_Angel_Baeyens

Hi Darshan,

That's right, but it takes more time to develop and you need to specify each of the files you want to concatenate, while when using the wildcard in the filename provided all fields are  the same, the concatenation takes places likewise, and the code is cleaner.

I use that quite a lot in my projects.

Regards.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

siva_boggarapu
Creator II
Creator II
Author

Hi Miguel,

I tried to store all qvds into one qvd as per your suggession. Yes, its working as well. But when Im going to see the final qvd. It is not showing any data. May I know why?

dkbhatt51
Contributor III
Contributor III

Hi Miguel,

If the aim is to load qvd files with different field names and create a single qvd file for further use, one can use the wild card for filename in my example as well. You may either keep the initial qvd files in a separate project directory or give them project related names like P1F1.qvd, P1F2.qvd and so on. You may then use "concatenate load * from *.qvd " if they are in a separate project directory, otherwise "concatenate load * from P1*.qvd ".

Hope this clarifies

Regards

Darshan

rahulgupta
Partner - Creator III
Partner - Creator III

Hey Hi siva,

Use the following code:

Finaltable:
Load *,'OverUnderFDUS2011' as TableName
from [..\Data Loader\Loader OverUnder\QVD\OverUnderFDUS2011.qvd](qvd);

concatenate

Load *,'OverUnderSTAFF2011' as TableName
from [..\Data Loader\Loader OverUnder\QVD\OverUnderSTAFF2011.qvd](qvd);

Concatenate

Load *,'OverUnderILS2011' as TableName
from [..\Data Loader\Loader OverUnder\QVD\OverUnderILS2011.qvd](qvd);

Concatenate

Load *,'OverUnderETCA2011' as TableName
from [..\Data Loader\Loader OverUnder\QVD\OverUnderETCA2011.qvd](qvd);

Concatenate

Load *,'OverUnderFDCA2011' as TableName
from [..\Data Loader\Loader OverUnder\QVD\OverUnderFDCA2011.qvd](qvd);

Concatenate

Load *,'OverUnderSTCA2011' as TableName
from [..\Data Loader\Loader OverUnder\QVD\OverUnderSTCA2011.qvd](qvd);

Concatenate

Load *,'OverUnderGACA2011' as TableName
from [..\Data Loader\Loader OverUnder\QVD\OverUnderGACA2011.qvd](qvd);

Store FinalTable into FinalTable.qvd (qvd);

TableName Field in the FinalTable.qvd will allow you to seperate the each table data on the selection in the front end(Optional).

Hope this solves your issue.

Regards

Miguel_Angel_Baeyens

Hello Siva,

Try a few files only, and see how large the file is in the folder, or if it's zero size.

Can you post your code or attach the application so we can take a closer look?

Regards.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

siva_boggarapu
Creator II
Creator II
Author

Hi Miguel,

Sorry to say this I’m unable to post my code or attachment.Because it’s very confidential file.

Miguel_Angel_Baeyens

Ok then,

What happens if you don't load all records from your file? Is the file empty?

ReducedTable:

LOAD *

FROM File*.qvd (qvd)

WHERE RecNo() < 10; // Load only 10 records from every file

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

siva_boggarapu
Creator II
Creator II
Author

Hi Miguel,

I tried with above code also, but still  final qvd was not showing any data.