The current limitation using Data Table but not being able to replace all data when using Data Shuttle makes Data Table very messy with Data that should not be there any longer. There is also no easy way to remove ALL entries to refresh Data Table (Currently only 100 lines per deletion) , It was also Suggested in the TT I opened
08561206
"from the TT"
Data Shuttle, when used with Data Table, has a known limitation where it does not support a direct "replace entire data set" action, unlike its functionality with regular Smartsheet sheets. This means that Data Shuttle can only add new rows or update existing rows in a Data Table, but it cannot automatically delete rows that are no longer present in the source file.
"
It was suggested to use Data Mesh to delete items however Data Mesh is not usable with Data Table. You can also not export from Data Table thus that's not an option either. Data Table is very useful but this "LIMIT" makes it very messy when using the data within Smartsheets. Without deleting the entire Data Table and re-creating it Daily (not an option) the use of Data Table becomes very limited.
What is needed is a feature that allows removal of Data (scheduled) or adding the replace feature to Data Shuttle when it's used to update data in Data Table.. This is a MUST have !!
