Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

batch processing for the upload of files in a table

Hello everyone,

I need some help. One of my upcoming projects consits a large quantity of files.

They have all the same format, but the number of files indefinit yet.

Maybe thousands in one folder. I think that I can load it with the help of a loop.


Does anyone know how I can determine the file name and read the data accordingly?

Thanks for your help!

2 Replies
Highlighted
MVP & Luminary
MVP & Luminary

If the files have all the same format you could load the files with a wildcard for the filenames. If not and/or you need to apply something then you could use dirlist/filelist to read all available / needed files from your storage, like:

Loop through Folders and sub folders to get file names

- Marcus

Highlighted
Partner
Partner

use the function

Filename()  gives the filename of the file loaded with extension

example: abc.scv

Filebasename() gives the  only the file name without extenion

example: abc

You can add these two functions in the script;

Load

filename()  as Filename

Filebasename()  as Filebaase, // followed by field names

...

...

...

...

from

abc*.csv;