batch processing for the upload of files in a table

[Anonymous]

Hello everyone,

I need some help. One of my upcoming projects consits a large quantity of files.

They have all the same format, but the number of files indefinit yet.

Maybe thousands in one folder. I think that I can load it with the help of a loop.

Does anyone know how I can determine the file name and read the data accordingly?

Thanks for your help!

[marcus_sommer]

If the files have all the same format you could load the files with a wildcard for the filenames. If not and/or you need to apply something then you could use dirlist/filelist to read all available / needed files from your storage, like:

Loop through Folders and sub folders to get file names

- Marcus

[shree909]

use the function

Filename()  gives the filename of the file loaded with extension

example: abc.scv

Filebasename() gives the  only the file name without extenion

example: abc

You can add these two functions in the script;

Load

filename()  as Filename

Filebasename()  as Filebaase, // followed by field names

...

...

...

...

from

abc*.csv;