Suppose you want Bouchard's rows before the other rows. You can modify the transformation as follows:
From the Flow category of steps, drag to the canvas an Append streams step. Rearrange the steps and hops so the transformation looks like this:
Edit the Append streams step, and select as the Head hop the one coming from Bouchard's stream. As the Tail hop, select the other hop. By doing this, you indicate to PDI how it has to order the streams.
Click on OK. You will notice that the hops coming to the step have changed the look and feel.
Preview the Add sequence step. You should see this:
You changed the transformation to give priority to Bouchard's issues.
You made it by using the Append streams step. By telling that the head hop was the one coming from Bouchard's file, you got the expected order: first the rows with the tasks assigned to Bouchard sorted by progress descending, then the rows with the...