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

Announcements
Join us in Toronto Sept 9th 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.