Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Load a series of csv files?

Hello Experts,

All my data files are in csv format with all the same field names and number of columns, and these data files are generated daily.

The question is: I am going to load all 31 files (file names are in sequence) for Oct 2013, can I use a single command line or one set of scripts to load all files or Do I have to load these 31 files one by one?

THANK YOU FOR YOUR HELP!!

1 Solution

Accepted Solutions
Not applicable

Re: Load a series of csv files?

Hello Frank,

Load

*

from  *.csv;   

Replace filename with the asterisk  (*).

Regards,

5 Replies
amars
Valued Contributor

Re: Load a series of csv files?

Hi Frank,

As long as all files have same format and column names you can use *.csv in place of the FileName.

Thanks....

Not applicable

Re: Load a series of csv files?

Thanks Michael,

but Can I load all 31 files at once using a single command line without repeating LOAD xxxx FROM xxx.?

Not applicable

Re: Load a series of csv files?

Hello Frank,

Load

*

from  *.csv;   

Replace filename with the asterisk  (*).

Regards,

amars
Valued Contributor

Re: Load a series of csv files?

Qlikview loads as many files as is present in the source. I personnaly load thousands of files using the same technique. There is no restriction on the number of files. Thanks...

Not applicable

Re: Load a series of csv files?

THANK YOU VERY MUCH!!

It works like a charm.

Community Browser