This might be an easy question for some but I'm trying to combine 2 Excel file outputs into 1 file in separate sheets. Does anyone have a simple solution for this?
I tried a solution I found on Google but am still kind of lost.
Any help would be greatly appreciated!
Solved! Go to Solution.
From your screenshot, we see that you use a tfilelist component before tfileinputexcel_1.
Do you want to combine a set of excel files?
Yes I want to combine 2 Excel files into one but are separated in different sheets. Both file paths are located in the tfilelist component.
I'm now a bit confused on what the file directory and sheet names should be on the tfilelist and tfileinputexcel components as I am encountering errors after I run my job.
Can you please clarify?
I was actually able to combine the Excel files using the "Append existing file" option box on my tfileOutputExcel of my last subjob.
Appreciate your input though!