Uploading an Excel with Data Shuttle Containing Duplicate Rows
I have a Data Upload workflow via Data Shuttle that runs on attachment for the most recent file. The excel files that stakeholders are uploading usually only have ~10 rows and when it goes through the workflow, the rows self-populate into the correct positions within a Smartsheet master database. The problem I have encountered is that sometimes the data being uploaded to Data Shuttle could contain a duplicate row that already exists within the Smartsheet. I want duplicates to be added to the bottom of the sheet like the rest of the new data already is, regardless of whether it is a duplicate or not. When there is a duplicate, Smartsheet doesn’t import that row into the sheet. Please let me know if this makes sense and any suggestions if you have them would be greatly appreciated.