topic Re: Extracting excel files data from subdirectories in Talend Studio

Extracting excel files data from subdirectories

Ghosh612 — Sat, 16 Nov 2024 02:58:56 GMT

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.

Re: Extracting excel files data from subdirectories

Anonymous — Mon, 16 Mar 2020 00:57:09 GMT

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

Re: Extracting excel files data from subdirectories

Ghosh612 — Mon, 16 Mar 2020 04:46:02 GMT

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