Quarry Operations receives a fresh roster and a payroll extract. The payroll reviewer asks separate questions about matched workers, roster-only workers and payroll-only workers. Each question needs a particular Join output. Keep the raw exceptions available while you decide whether a padded identifier, a missing record or a duplicate source row explains the difference.
Other requests stack team exports rather than match workers. Use Union's name mapping when source columns arrive in a different order, and remember that stacking retains duplicate records. A clean final row count can hide a misplaced amount, so inspect the field values as well. These exercises reuse preparation and combining skills; none requires a new connector or a workplace file.