How to merge streams in Pentaho?

Question

I've got a job that loads three Excel-files from FTP to local drive and then launch three different transformations doing som normalization etc. and then output the data again to Excel and finally put them to FTP a site again:

This is the main job:

The main job starts three of this, each converting from one Excel file to another. Every output Excel file is just rows with data with equal number of columns. WHat I'd like to do is to merge the rows into one file.

How can this be done?

Answer 1

You can also try out the 'Append streams' step. Again, all of the Excel inputs would have to have matching metadata for this to work.