DataMesh - Lookup value in Source deleted - target keeps stale data?
when a row lookup value column is deleted in the Source sheet, this change is not being updated in the target.
I'm mapping two sheets based on a unique key, and run data mesh. All selected columns are now copied over to the target. But when I now delete a row in the source, the next time DataMesh runs the data in the target will remains unchanged, because there is no lookup value anymore. Instead I'd expect the previously copied data also to be deleted in the target.
I thought I could solve this by using the "Create Cell Links" option, but in the scenario above DataMesh only removes the cell link, but leaves the data untouched.
Is there any workaround to this?