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.
Answers
-
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.
-
I thought that as well, but I can not find a way to identify the obsolete rows.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives