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 reload multiple QVD's at once?

Hi there,

How to reload multiple QVD's at once?

1 Solution

Accepted Solutions
siva_boggarapu
Creator II
Creator II
Author

Hi,

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

View solution in original post

9 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

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

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
siva_boggarapu
Creator II
Creator II
Author

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;

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
siva_boggarapu
Creator II
Creator II
Author

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?

siva_boggarapu
Creator II
Creator II
Author

Hi there,

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

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
siva_boggarapu
Creator II
Creator II
Author

Hi,

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

Not applicable

Hi,

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

rbecher
MVP
MVP

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

Astrato.io Head of R&D