https://community.qlik.com/t5/Talend-Studio/How-to-read-Multiple-Excel-File-from-Different-Folders/m-p/2283787#M57617 Try<BR /><BR />Tfilelist —- tfileinputexcel — tlogrow<BR /><BR />Check options on these component. You could select subfolders and only need execl file based on regex pattern.<BR /><BR /> Sat, 30 May 2020 11:22:39 GMT akumar2301 2020-05-30T11:22:39Z https://community.qlik.com/t5/Talend-Studio/How-to-read-Multiple-Excel-File-from-Different-Folders/m-p/2283786#M57616 <P class="_1qeIAgB0cPwnLhDF9XSiJM">Hello All,</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">This is my first day with Talend, I came from Alteryx.</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">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.</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">The 3 steps shows all the files, and there are two other similar folders with similar structures named 01b Transactions Data,&nbsp;01c Transactions Data&nbsp;&nbsp;</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">I need to read all files, including the sub directories.&nbsp;</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">Thank You.</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">The records are continuing in the files.</P> Sat, 16 Nov 2024 02:17:24 GMT https://community.qlik.com/t5/Talend-Studio/How-to-read-Multiple-Excel-File-from-Different-Folders/m-p/2283786#M57616 Anonymous 2024-11-16T02:17:24Z https://community.qlik.com/t5/Talend-Studio/How-to-read-Multiple-Excel-File-from-Different-Folders/m-p/2283787#M57617 Try<BR /><BR />Tfilelist —- tfileinputexcel — tlogrow<BR /><BR />Check options on these component. You could select subfolders and only need execl file based on regex pattern.<BR /><BR /> Sat, 30 May 2020 11:22:39 GMT https://community.qlik.com/t5/Talend-Studio/How-to-read-Multiple-Excel-File-from-Different-Folders/m-p/2283787#M57617 akumar2301 2020-05-30T11:22:39Z