Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Hi QFabian,
the '*' works fine, thank you for you´re help.