How to use Data Shuttle to add rows without erasing changes made to target sheet?

swfascetti

I am using Data Shuttle to transfer a sheet of individual people activity from a source sheet to a target sheet.

I want to be able to add notes to the target sheet or check boxes in columns that are on the target sheet and not the source sheet. I set up DS to merge data into the target based on a key column value. Each time DS runs it erases all information on the target sheet and replaces it. I've tried this with different row options (add rows or add rows and update or just update) with no success.

Ideally, I would add new rows and update information on existing rows without removing comments, or data added to columns not on the source sheet.

Thanks, Sara

Tim C

Hi Sara, thats not typical behavior. The comments and other column data should remain.

My first thought would be, what's your data shuttle run frequency? And Are you able to save the info in your target sheet before the workflow runs again?

Eric Sivacis

https://community.smartsheet.com/discussion/comment/416193#Comment_416193

How can i shuttle data from one sheet that i dont have admin powers in to another that i do?

Danielle Wilson

@Eric Sivacis I answered on your other post, but I'd recommend DataMesh instead of Data Shuttle for this