Merging streams in several ways

You have just seen how the rows of a dataset can take different paths. Here you will learn the opposite, how data coming from different places are merged into a single stream. We will break this section into two parts:

• Merging two or more streams
• Customizing the way of merging streams

Merging two or more streams

For demonstrating how to merge streams, let's export a new file from the JIRA website. Following the same instructions as before, we will export the issues with a different set of filters:

• Project: Pentaho Data Integration - Kettle
• Issue Type: Bugs
• Status: All excepting CLOSED and RESOLVED

This time, instead of exporting the current fields, we will select the option Excel (All fields).

If you open the Excel file, you will note that this version contains much more information as compared to the previous version. 

Now we have:

• One Excel file containing new features for PDI.
• A second Excel file containing the list of unresolved bugs of PDI. This file has many more...