Load all CSV´s in One Folder

[RudiJoa]

Hey there,

I have an folder with many csv Files and I get new files in this folder every month. They all have the same Fields and I´m searching a possibility to load all CSV Files in this Folder in one Table automatically. Is there a possibility without using the Concatenate for every File?

Like Concatenate all Tables in Folder "xy"?

Thanks for you´re ideas in advance.

Rudolf

[QFabian · Accepted solution]

Hi @RudiJoa , it should be simple, using  *, to read all files in folder like this :

LOAD
fields
FROM [lib://desktop (fabian_fabian)/*.csv]
(txt, utf8, no labels, delimiter is '\t', msq);

Please let my know if it is an acceptable solution for you

[RudiJoa]

Hi QFabian,

the '*' works fine, thank you for you´re help.