Data Shuttle: Missing Rows/Entries

MelissaYE

I have two workflows in DataShuttles set up to track costs on a monthly basis in a single sheet. One workflow is called "Current Month Cost" and the other is "Previous Month Cost." The sources are excel files from an external database that I have no control over.

Every month, I take the previous month's excel file and run it in "Previous Month's Cost" to populate the "Previous Cost" column. I then run the database to get an updated report to populate the "Cost" column. I use a formula to calculate the cost differential and formatting rules to highlight when the "cost differential" is outside a certain range.

My problem is that there is no way within the database to track if an entry is deleted. So, if the resources in the row where the Unique ID is "S027" are removed, there is no status column from the database to let me know that the cost has been removed, it simply does not appear, along with the UniqueID.

Is there a way for me to use DataShuttle to show that a Unique ID from the previous report does not appear in the current report?

alyssad

This isn't a fix, more of a workaround but you can change your data shuttle to inly add and update, instead of add, update and delete so if the new data isn't there you just keep the old data and then when you turn on highlight changes you'll see which unique ID's didn't change and therefore don't have stats for that month