Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi
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
Hi
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
checking the 'append existing file' and 'append existing sheet' box on tFileOutputExcel worked 🙂
Thank you very much