Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to read Multiple Excel File from Different Folders???

Hello All,

This is my first day with Talend, I came from Alteryx.

What I would like to ask is how can I read multiple excel files from different folders. Let me provide you with a screenshot of the folder structure.

The 3 steps shows all the files, and there are two other similar folders with similar structures named 01b Transactions Data, 01c Transactions Data  

I need to read all files, including the sub directories. 

Thank You.

The records are continuing in the files.

Labels (3)
1 Reply
akumar2301
Specialist II
Specialist II

Try

Tfilelist —- tfileinputexcel — tlogrow

Check options on these component. You could select subfolders and only need execl file based on regex pattern.