Time for action – gathering progress and merging it all together

Suppose that you delivered the Excel files you generated in the sections on assigning tasks by filtering priorities. You gave the b_bouchard.xls to Benjamin Bouchard, the senior programmer. You also gave the other Excel file to a project leader who is going to assign the tasks to different programmers. Now they are giving you back the worksheets with a new column indicating the progress of the development. In the case of the shared file, there is also a column with the name of the programmer who is working on every issue. Your task is now to unify those sheets.

Here is how the Excel files look:

  1. Create a new transformation.
  2. Drag to the canvas a Microsoft Excel Input step and read one ...

Get Pentaho Data Integration Beginner's Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial