Data Mesh - Total Rows Not Matched, can I delete them?

Andrea Vecchi

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.

markkrebs

You could do a formula to flag the obsolete rows (assuming there is a clear indication of obsolescence) and then use move rows automation to get them out of the sheet.

Andrea Vecchi

https://community.smartsheet.com/discussion/comment/276655#Comment_276655

I thought that as well, but I can not find a way to identify the obsolete rows.