topic How to reload multiple QVD's at once? in QlikView

How to reload multiple QVD's at once?

siva_boggarapu — Wed, 20 Jul 2011 07:47:39 GMT

Hi there,

How to reload multiple QVD's at once?

kaushiknsolanki — Wed, 20 Jul 2011 07:49:28 GMT

Hi,

Can you please describe in detail, what you want, if possible with example.

Regards,

Kaushik Solanki

Re: How to reload multiple QVD's at once?

siva_boggarapu — Wed, 20 Jul 2011 07:53:12 GMT

Hi There,

I have 12 qvd files. When Im going to reloading all qvd files. It is stuck some where. Can any once please give answer on this.

Load *from GAUSLoaderoverunder2011;

Load *from COUSLoaderoverunder2011;

Load *from ETCALoaderoverunder2011;

Load *from EAUSLoaderoverunder2011;

Load *from FDUSLoaderoverunder2011;

How to reload multiple QVD's at once?

kaushiknsolanki — Wed, 20 Jul 2011 07:58:23 GMT

Hi,

What kind of error you are getting.

Also generate the log file.

The way to generate log file is as below.

Open the application->Settings-> Document Properties -> general tab-> Click on Generate LogFile

Now realod the document.

The log file will be generated at the same location where you have you application stored(Path)

Upload the log file here for more info.

Regards,

Kaushik Solanki

Re: How to reload multiple QVD's at once?

siva_boggarapu — Wed, 20 Jul 2011 07:58:35 GMT

Hi Kaushik,

Please have a look my requirement,

Load *from GAUSLoaderoverunder2011;

Load *from COUSLoaderoverunder2011;

Load *from ETCALoaderoverunder2011;

Load *from EAUSLoaderoverunder2011;

Load *from FDUSLoaderoverunder2011;

I need to reload all qvd files at once. Is it possible? If possible?

Re: How to reload multiple QVD's at once?

siva_boggarapu — Wed, 20 Jul 2011 08:00:41 GMT

Hi there,

I didnt get any error while reloading. Simply it was stuck somewhere.

How to reload multiple QVD's at once?

kaushiknsolanki — Wed, 20 Jul 2011 08:03:28 GMT

Hi,

Ok the reason for this is that there will be many fields which are same in those qvds.

So qlikview tries to join them and thus it is stuck.

You need to identify those fields and you need to rename them.

Regards,

Kaushik Solanki

How to reload multiple QVD's at once?

siva_boggarapu — Wed, 20 Jul 2011 08:10:17 GMT

Hi,

Yes, you are right. There are so many similar fields for all qvd files.

How to reload multiple QVD's at once?

Wed, 20 Jul 2011 08:18:59 GMT

Hi,

Isn’t the whole idea ofdoing this to join all similar field under the same tablename?

How to reload multiple QVD's at once?

rbecher — Mon, 30 Jan 2012 21:33:11 GMT

If you want to load different QVDs into one table just use CONCATENATE at the second++ QVD:

mytable:

LOAD * FROM myfile1.qvd (qvd);

mytable:

CONCATENATE LOAD * FROM myfile2.qvd (qvd);

mytable:

CONCATENATE LOAD * FROM myfile3.qvd (qvd);

...etc.

- Ralf