Can it be done? Data Shuttle to automate identification of differences between two excel sheets (one column in particular) with over 10,000 rows.
Basically what the title says. I want to automate a process and was pointed in the direction of Data Shuttle to accomplish this.
I have a regularly reoccurring excel sheet that, at each interval, will have a difference from the previous iteration of 1-100 rows (estimating), out of over 10,000 rows.
I'd like to automate a process that lets me upload the excel sheet after each interval and have Smartsheet tell me how many rows have changed and which rows changed. Ideally the rows that remained the same would be removed from the result and only show the ones that changed.
To my understanding, these are the only options, so not sure if this is even possible, much less how to get it done.
The excel sheet itself is private so I cannot share that or the Smartsheet it's based in.