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:
Drag an Excel Input step to the canvas and read one of the files.
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.
After the filter, add a Sort rows step, and configure it to order the fields...