I have a DataTable that is currently populated by a DataShuttle. When I upload the source report to a sheet, the data gets added into the DataTable via DataShuttle. The DataShuttle is configured to "add rows when added to the source file" and "update rows as they change in the source file". The unique column identifier is the "Charge ID" in the source report.
There are times in our business process when a Charge ID that is generated for a specific line of data gets removed from the report, and added under a new Charge ID.
Because the DataShuttle only ever has new lines added (and not removed), this means that the same data is getting added into the DataTable under two unique Charge IDs.
Is there a way to fix this so that DataShuttle removes rows from the DataTable that no longer exist in the source sheet? The filter option doesn't work in this case, because the first Charge ID line is completely removed from the source report vs. getting updated with a certain filter criteria.
