Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.