Why does my DataMesh Duplicate instead of updating cells?
I Built both of my templates, and Mapped them through DataMesh. I have removed any columns with formulas and auto generated numbers columns. I have set My lookup Values to a unique job name that would belong to a row. All columns throughout match in name and positioning for both sheets. I have the "Overwrite Existing Data in Target Sheet" option set to yes. The intended function is when I update any cell that are mapped in the source sheet I want it to update the same rows that were initially generated in the target sheet, but instead what it is doing it keep duplicating rows in my Target Sheet. What can I do about this?