Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
mathew101
New Contributor II

Load from folder - CSV

Hi All,

Using the Desktop App, is there a method to load all files from a folder via the add data from files and other sources, or do we need to use the script editor?

Cheers

Mathew

Labels (3)
1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Load from folder - CSV

You'll have to use the script editor. But first you can use the Data Manager to create the load statement for one file. Once you've done that you change over to the data load editor and unlock the autogenerated section. It will contain a load statement with a line containing FROM LIB://something/somefilename.csv ...etc. In that part you can change the somefilename.csv part with *.csv. And that's it. The * wildcard will make the load statement load all the csv files.


talk is cheap, supply exceeds demand
2 Replies
MVP & Luminary
MVP & Luminary

Re: Load from folder - CSV

You'll have to use the script editor. But first you can use the Data Manager to create the load statement for one file. Once you've done that you change over to the data load editor and unlock the autogenerated section. It will contain a load statement with a line containing FROM LIB://something/somefilename.csv ...etc. In that part you can change the somefilename.csv part with *.csv. And that's it. The * wildcard will make the load statement load all the csv files.


talk is cheap, supply exceeds demand
mathew101
New Contributor II

Re: Load from folder - CSV

It's a pity, that the Data Manager (GUI) is not more powerful to allow for dealing with Folders and merges/appending data