Sign in to submit new ideas and vote
Get Started

Data Shuttle to DataTable: Replace DataTable

I want to create an automated system that maintains my DataTable as an exact replica of a source file. Data Shuttle does not quite do this for a DataTable workflow. In the Data Shuttle workflow for DataTables you can only Add and/or Update data. This can result in rows of data remaining in the DataTable when they are no longer in the source file thereby creating discrepancies between the source file and the DataTable.

In the Data Shuttle workflow for sheets, there are options to Replace the entire data set and to Delete rows that no longer match the filter criteria. I'd like to have the option to Replace the entire DataTable using Data Shuttle, which would ensure that the DataTable always contains the same data as the source file.

5 votes

Idea Submitted · Last Updated