Data Table clean up

jpaul

There is currently not a way to clean up data tables efficiently, only continue adding data to them. Would be good to be able to run some type of clean up on the table to remove data that is no longer needed. This would also help free up server space.

Holly Rumble

Hi @jpaul

Thanks so much for the feedback, would love to connect with you on this topic as it's something we are investigating.

CW Wright

@jpaul I need this too! thank you

Danielle Wilson

@jpaul If you're going to be at Engage, come by and chat with Holly and me at the Data Connections booth! We'd love to get some more feedback from you on this.

Neil Egsgard

Yes, please! We need the ability to automatically remove bad data from DataTable.

My workaround is to put a "Record date" field on each record in the source. I use the DataTable connection filter to only include records with a "Record date" field = to the update frequency of the data.

For example:
- if the data refreshes daily, the DataTable connection filters records with a "Record date" = today or yesterday.

- if data refreshes every 3 days, the DataTable connection filters records with a "Record date" = 3 days ago or 4 days ago

Including one additional day reduces data accuracy but ensures date mismatches between Smartsheet and the data source don't remove data.

Brad Powers

@Danielle Wilson have there been any developments on this? We really need to be able to delete more than 100 rows of data at at a time. A "Select All" option on filtered data for deleting rows in the DataTable would manage this nicely.

Danielle Wilson

@Brad Powers Nothing that I've recently heard back from the team but I'll pass along the feedback!

jpaul

https://community.smartsheet.com/discussion/comment/393850#Comment_393850

@Holly Rumble, would love to connect with SS and show the use cases.

Danielle Wilson

@jpaul I'll follow up with you over email!