DataMesh not returning any values

edye

Any suggestions why this continues to not find and copy over the values from my source sheet to the destination.

Two columns. "Project Name" which is the primary on the source to a same name on the blank destination. And then the "PM Assigned" column from source to the same name column on destination. Two pics below setup.png and the source.png

Setup.png

edye

I got it to work but i realize it will only work if the source data is already in the target file to find a match. What do I do if I source data has a new column. What can I do to have that automatically then copy over to the target? i looked at Data Shuttle but that seems to need an external csv file. I just want any new roles in source to copy to target

Gia Thinh

Hi @edye

I can see that you selected Copy and Add Data in your Datamesh settings. This will allows DataMesh to copy newly added rows from the source sheet to the target sheet based on mapped columns. This setting does not copy the newly added columns from the source sheet to the target sheet.

You need to manually add new columns to the target sheet and re-configure the column mapping.