topic Job not wanting to select all excel files in Talend Studio

Job not wanting to select all excel files

Mahdi — Fri, 15 Nov 2024 22:01:39 GMT

Hi all,

So I'm trying to merge 12 small excel files into 1 big file, but the problem is that talend selects only 1 file and takes it the target file and not the 11 other files. This is the job I'm currently using.

Would be great if you can support me on this

Thanks a lot.

Re: Job not wanting to select all excel files

Anonymous — Mon, 06 Mar 2023 23:03:53 GMT

Use a tUnite component to merge all records before writing them into the file or check both of the 'append existing file' and 'append existing sheet' box on tFileOutputExcel.

Regards

Shong

Re: Job not wanting to select all excel files

Mahdi — Mon, 06 Mar 2023 23:14:04 GMT

checking the 'append existing file' and 'append existing sheet' box on tFileOutputExcel worked 🙂

Thank you very much