Data Mesh - Total Rows Not Matched, can I delete them?
I have just started using data mesh and I have the following issue I can't find a way to solve.
If in my source sheet the Lookup Value cell of a row is edited, for example because there was a spelling mistake, when the data mesh run, it will create a new row in the target sheet, but the "old" row with the previous cell value, that now doesn't exist anymore in the source sheet, will remain in the target sheet. The data mesh flag this by saying that 1 new row has been added (the one from the source sheet with the updated Lookup Value cell) and 1 row is unmatched (the one in the target sheet with the old Lookup Value cell).
This is an issue to me as I am doing few calcs on the target sheet, and therefore I would like to delete this obsolete row.
Is there a way to do this?
In the data uploader app for example I can flag to delete the unmatched rows.