Why does my DataMesh Duplicate instead of updating cells?

Good Day,

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?

Answers

  • Genevieve P.
    Genevieve P. Employee Admin

    Hey @RayL

    Is there any possibility that the job name is somehow being seen as a new value, instead of the same one? How are you creating the Job Number?

    It would be helpful to see a screen capture of your source and destination sheets, but block out sensitive data.

    Thanks,

    Genevieve