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:
Create a new transformation.
Drag to the canvas a Microsoft Excel Input step and read one of the files.
Add a Filter rows step to keep only the rows where the progress is not null, that is, the rows belonging to tasks whose development has been started.
After the filter, add a Sort rows step, and configure it to order the fields by
Progress...