Load from folder - CSV

[mathew101]

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

[Gysbert_Wassenaar · Accepted solution]

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.

[mathew101]

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