Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

we can load more than one file at a time?

we can load more than one file at a time ?

if yes please explain it

9 Replies
ashwanin
Specialist
Specialist

Yes , we can.

Open

Script

Load File 1:

and after it Load the another 2:

You can load multiple files/qvd's in QV.

Not applicable
Author

Yes,But all the files having some fields.

for ex:-

Load *

from *.Qvd;

Not applicable
Author

hi

see attached file

puttemans
Specialist
Specialist

Basically you can't. You can load multiple files in a script (one after the other or with some iteration script), as mentioned already, but opening several files in one go is not possible. This comes basically because you need to tell Qlikview for each individual file that you load how you want the program to treat the variables and the file.

Not applicable
Author

i am asking how to read multiple files at a time?

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

     Have a look at the links below.

     http://community.qlik.com/thread/72327

     http://community.qlik.com/message/223844#223844#223844

     http://community.qlik.com/thread/91263

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
rahulgupta
Partner - Creator III
Partner - Creator III

Hi Vuyyuru,

You can load multiple files at a time using the File Functions in Qlikview, for example:

for each Ext in '*.*'

     for each File in filelist (Root&'\*.'&Ext)

          Load

               FileName('$(File)') as FileNameOrig,

               FileExtension('$(File)') as FileExtensionOrig

          autogenerate 1;

     next File

next Ext

Hope this helps.

Regards

Rahul

senpradip007
Specialist III
Specialist III

Hi.

Basically you can't load two files in a single QlikView application at a time. To acheive it you have to load data from two files creating two different QV apps and run those simmultenously or schedule it through QMC.

manojkulkarni
Partner - Specialist II
Partner - Specialist II

Loading multiple files at same time is not possible. Either you have to use loop thru files or if all files having same data then use filepath/*.ext in load script;