Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Solving the Informatica Dilemma: On-Demand Briefing - Watch On Demand!
cancel
Showing results for 
Search instead for 
Did you mean: 
mathew101
Contributor II
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 (1)
1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

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

View solution in original post

2 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

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
Contributor II
Contributor II
Author

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