Data Shuttle Synch Capability

Options

Hello - I need to set up a sheet based on an employee roster that will be updated quarterly. I'd like to use a Data Shuttle upload workflow to attach the updated roster to the sheet and have it automatically remove termed employees and add new rows for those that are new hires, without deleting the existing rows in the sheet. I have set up a workflow to successfully add rows for the new hires, but when I attempt to add a delete for terms it removes all existing rows from the sheet. What's the best way to accomplish this? Is it two separate workflows? Thanks in advance for any guidance or insight.

Answers