topic How to save multiple qvds into one qvd? in QlikView

How to save multiple qvds into one qvd?

siva_boggarapu — Tue, 26 Jul 2011 12:40:37 GMT

Hi there,

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

How to save multiple qvds into one qvd?

Tue, 26 Jul 2011 12:58:32 GMT

Hi,

you can do something like:

ALL_QVD:

load null() as dummy autogenerate(0);

// this is needed for making the concat afterwards

for each qvd_file in filelist ('c:\your_qvd_dir\*.qvd')

concatenate (ALL_QVD)

load *

from $(qvd_file) (qvd);

next qvd_file

drop field dummy;

store ALL_QVD into ALL_QVD.QVD;

Take a look on syntax because I don't have test it.

Hope that help!

Andrea

How to save multiple qvds into one qvd?

danielrozental — Tue, 26 Jul 2011 13:31:56 GMT

Why do you need to build them into one? what's the problem on keeping them separated?

How to save multiple qvds into one qvd?

Tue, 26 Jul 2011 13:51:20 GMT

You Could simply say,

Test_QVD:

Load *

From ;

Store Test_QVD into [TEST\Final.QVD];

This should work.

-Sridhar

How to save multiple qvds into one qvd?

danielrozental — Tue, 26 Jul 2011 13:54:56 GMT

Sridhar, that will only work if all qvd files have the same fields, if not you will end up having Test_QVD_1, Test_QVD_2, etc.

Andrea's answer is more generical in that regard.

How to save multiple qvds into one qvd?

Tue, 26 Jul 2011 14:11:20 GMT

Exactly, my solution will work when the field names are same in all QVD`s.

When siva.boggarapu said about concatenating all the QVD`s in to one QVD, I have assumed that he may have the same field names in all QVD`s.

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.

Apologies for my misunderstandings and i accept Andrea`s answer is more generical in that regard.

- Sridhar

How to save multiple qvds into one qvd?

Tue, 26 Jul 2011 14:44:57 GMT

I use this solution more generally for TXT or XLS files. I just propose it because is , as you said, more generic.

In fact the Sridhar method is quite more efficent if the case of same fields.

Andrea

How to save multiple qvds into one qvd?

siva_boggarapu — Wed, 27 Jul 2011 04:20:19 GMT

Hello Danielato,

Could you please understand my requirement. I need to make them as single qvd file. Is it possible?

Load *from [..\Data Loader\Loader OverUnder\QVD\OverUnderFDUS2011.qvd](qvd);

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

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

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

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

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

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

Re: How to save multiple qvds into one qvd?

Miguel_Angel_Baeyens — Wed, 27 Jul 2011 08:01:18 GMT

Siva,

Shridar already answered you here. Your code, would look like

// This loads all files in one table
TempLoad: 
LOAD * 
FROM [..\Data Loader\Loader OverUnder\QVD\OverUnder*.qvd] (qvd);
// This stores all previous QVDs in one
STORE TempLoad INTO [..\Data Loader\Loader OverUnder\QVD\CompleteFile.qvd];

Credits to Shridar.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

How to save multiple qvds into one qvd?

Wed, 27 Jul 2011 08:02:46 GMT

Hi,

if in the directory you have only the qvd that you mention you can do:

ALL_QVD:

load null() as dummy autogenerate(0);

// this is needed for making the concat afterwards

for each qvd_file in filelist ('..\Data Loader\Loader OverUnder\QVD\*.qvd')

concatenate (ALL_QVD)

load *

from $(qvd_file) (qvd);

next qvd_file

drop field dummy;

store ALL_QVD into ALL_QVD.QVD;

Re: How to save multiple qvds into one qvd?

siva_boggarapu — Wed, 27 Jul 2011 08:03:56 GMT

Hi Miguel,

Thank you

Re: How to save multiple qvds into one qvd?

dkbhatt51 — Wed, 27 Jul 2011 17:14:06 GMT

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

Re: How to save multiple qvds into one qvd?

Miguel_Angel_Baeyens — Wed, 27 Jul 2011 17:35:43 GMT

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

Re: How to save multiple qvds into one qvd?

siva_boggarapu — Thu, 28 Jul 2011 04:53:35 GMT

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?

Re: How to save multiple qvds into one qvd?

dkbhatt51 — Thu, 28 Jul 2011 05:02:52 GMT

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

How to save multiple qvds into one qvd?

rahulgupta — Thu, 28 Jul 2011 07:10:45 GMT

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

Re: How to save multiple qvds into one qvd?

Miguel_Angel_Baeyens — Mon, 01 Aug 2011 08:49:33 GMT

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

Re: How to save multiple qvds into one qvd?

siva_boggarapu — Mon, 01 Aug 2011 08:54:46 GMT

Hi Miguel,

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

Re: How to save multiple qvds into one qvd?

Miguel_Angel_Baeyens — Mon, 01 Aug 2011 09:52:40 GMT

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

Re: How to save multiple qvds into one qvd?

siva_boggarapu — Tue, 02 Aug 2011 09:29:05 GMT

Hi Miguel,

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