Harbor Operations has separate roster, payroll and assignment files. The reviewer needs to know which workers have complete source coverage before the final handoff. Don't replace an absent assignment with an arbitrary row just to make the result longer. The input keys and their multiplicity determine the output.
The replacement tasks use controlled team codes, including case differences. The parameter tasks attach one or two reporting periods so you can see the count effect of Append Fields. A successful run doesn't decide whether a lookup or a Cartesian product fits the request; you make that choice from the business meaning. Keep unmatched codes visible and inspect how many records each tool produces. These tasks reuse the matching and enrichment tools on new fixtures.