DataMesh Config : Duplicate Values in Source Sheet
I am looking for a solution/workaround for DataMesh not only to return the 1st Match currently set up in the config settings: "Duplicates in Source Sheet", but also any match that follows.
I have the source sheet in which entries are fed via Form and I have set an automation "Copy to Another Sheet" when a certain criteria is met. I created a Datamesh Config between the two sheets as I wanted the values to be updated in the Target sheet whenever there is an update in the Source Sheet.
Now, the lookup value that I selected is "Opportunity Name" but sometimes the Lookup value is duplicate i.e. we have two or more projects for same Opportunity due to which data is lost for the new projects.
Please share some workaround for this.