Qlik Community

Ask a Question

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
RudiJoa
Partner
Partner

Load all CSV´s in One Folder

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

1 Solution

Accepted Solutions
QFabian
Specialist II
Specialist II

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

QFabian

View solution in original post

2 Replies
QFabian
Specialist II
Specialist II

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

QFabian

View solution in original post

RudiJoa
Partner
Partner
Author

Hi QFabian,

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