topic Re: Load all CSV´s in One Folder in Connectivity & Data Prep

Load all CSV´s in One Folder

RudiJoa — Thu, 18 Feb 2021 12:24:00 GMT

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

Re: Load all CSV´s in One Folder

QFabian — Thu, 18 Feb 2021 14:37:12 GMT

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

Re: Load all CSV´s in One Folder

RudiJoa — Thu, 18 Feb 2021 14:55:56 GMT

Hi QFabian,

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