Extracting excel files data from subdirectories

[Ghosh612]

Dear All, I am trying to get 4 different excel files from 2 directories to be displayed in and output file. 

The folder structure is:

File 1:

\01 Data\01a Transactions Data\Retail Transactions 2020.xlsx

File 2-4

\01 Data\01a Transactions Data\Historical Files\Retail Transactions 2020.xlsx

                                                                           \Retail Transactions 2019.xlsx

                                                                           \Retail Transactions 2018.xlsx

                                                                           \Retail Transactions 2017.xlsx

Total 4 files.

I am uploading an image of my job that Ive created.

I am new to Talend, my task involves "master data" joins. Before this I was using Alteryx and Knime, for the above I have tried, the image is below, but the problem is that I cannot display all the data in the output file, only the file outside of "Historical File" can be read, not the ones inside (checked the Sub-directories option). 

Thank You.

[Anonymous · Accepted solution]

Hi
From your images, I can see there are total 4 files are found, make sure you have checked the 'append' box on tFileOutputDelimited component if you want to append all data into one file.
BTW, please insert images into your post body instead of attaching them.

Regards
Shong

[Ghosh612]

Thank you Shong, works after append. but also I had to stop putting repository instead of built in, As I said, lot to learn here that I have