Add Unmatched source data from DataMesh

Jacqueline Ennis

I am using DataMesh to update a staff file each month. The source sheet contains the names of all staff - some of whom are new and are not in the target sheet. The Target sheet also contains the names of all staff but also has the names of terminated staff not listed in the source file. I would like to add the new staff from the source sheet to the target sheet (I think these are labeled as unmatched) how do I do this?

Thanks

Matt Johnson

Hi @Jacqueline Ennis

On step 4 in the datamesh configuration, make sure the 3rd option, Data Mapping Format, is set to "Copy and Add Data". That should do it.

Matt

Jacqueline Ennis

Thanks Matt. I had that on one of my attempts but it did not work. It has worked before. With the confirmation you provided I think I will set up the DataMesh again. I must have done something incorrect.

Thanks again