Data Shuttle not deleting rows

TimMelton

Hi all,

Im new to data shuttle, implementing my first workflow.. overall its working fine, but what its not doing is deleting records when I attach new data to my source sheet. The scenario is, the source sheet contains a row thats not in the updated data. My expectation is when data shuttle runs it finds a target row where the unique identifier no longer exists in the new data and it deletes it in my datatable. Im not finding an option for that action in data shuttle.. what am I missing?

Thanks

Paul Newcome

It is in the target settings.

Paul Newcome

It is in the target settings.

TimMelton

Thanks, appreciate the response.. odd that you cant see that option when you edit a workflow.

Paul Newcome

It is there for me when I edit. It also depends on "Workflow Action" selected, and it could also be lower on the page requiring you to scroll down depending on a few variables.

TimMelton

Interesting.. I tried creating a sheet to sheet of the same workflow and the field shows, but going into data table it does not. I'm using data table because of the size of the data set, but I suppose I can break out into multiple grids if datatable doesn't support deletes. Thanks again for the input.

Paul Newcome

Yes. Data Table as opposed to a sheet makes a difference.

DataTable | Smartsheet Learning Center

https://help.smartsheet.com/learning-track/integrations-and-add-ons/datatable

Visualize and collaborate on large data sets.

TimMelton

Appreciate the help Paul.