Data Mesh Unmatched & Unaffected

WillLaw

I'm having issues with my Data Mesh config seeing the data, but not acknowledging that it needs to move the rows over.

0 Total rows affected

66 Total rows unaffected

0 Total duplicates in Source

57 Total rows unmatched

0 Total formula cells skipped

0 Total nonexistent data fields mappings skipped

0 Total new rows added

I have it set to use a field as the lookup value.

Config step 4 to Define View Options i have the following

Overwrite : yes

Duplicate in source sheet: pick 1st match

data mapping format: Create Cell Links

Excecution Frequency: Immediately

I guess i need help understanding why the rows are unaffected and unmatched, but not being able to see which rows are in question.

Melissa Yamada

Hi @WillLaw

Could you provide a screenshot of your DataMesh configuration? It will only map over data if the lookup values match exactly on both sheets.

WillLaw

@Melissa Yamada This is the sheet, i thought that the purpose of having the data fields mapped was to allow for different friendly names.

Melissa Yamada

@WillLaw Thank you. Using Email as the Lookup Value can be tricky as it needs to be an exact match. For example if on one sheet it is a Contact field and displays the nickname and on the other sheet it shows the full email address, Data Mesh may not recognize this as an exact match and will not run. I believe upper case / lower case also affects whether it runs.