Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Mahdi
Contributor III
Contributor III

Job not wanting to select all excel files

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.

Labels (4)
1 Solution

Accepted Solutions
Anonymous
Not applicable

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

View solution in original post

2 Replies
Anonymous
Not applicable

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

Mahdi
Contributor III
Contributor III
Author

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

 

Thank you very much