Time for action – gathering progress and merging all together

Suppose that you delivered the Excel files you generated in the Assigning tasks by filtering priorities tutorial earlier in the chapter. 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 what the Excel files look like:

1. Create a new transformation.

2. Drag an Excel Input step to the canvas and read one of the files.

3. Add a Filter row step to keep only the rows where the progress is not null, that is, the rows belonging to tasks whose development has been started.

4. After the filter, add a Sort rows step, and configure it to order the fields...