Data Shuttle - Remove row that is no longer is source sheet

Katherine Britt

I use Data Shuttle to upload current enrollment data for our courses. I have a unique identifier because the source sheet has duplicate entries, but I only need one in entry in Smartsheet.

Has anyone come up with a solution to remove the a row that is in Smartsheet, but no longer in your source sheet?

Sometimes courses are deleted and there isn't a way to do this in Data Shuttle. I need a combination of the replace data option and the merge data option. Any ideas?

Danielle Wilson

@Katherine Britt If the records that are no longer in your source sheet have some kind of commonality for them, you could use the "Delete rows that no longer match the filter criteria" option in Data Shuttle. Otherwise there are probably some options that have to do with making sure you're not bringing in duplicate entries so you can use the course ID as the unique ID, which should solve it - though that might involve a staging sheet and DataMesh.