Data Mesh Unmatched & Unaffected
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.
Answers
-
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.
Melissa Yamada
melissa@insightfulsheets.com
Data made simple, spreadsheets reimagined -
@Melissa Yamada This is the sheet, i thought that the purpose of having the data fields mapped was to allow for different friendly names.
-
@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.
Melissa Yamada
melissa@insightfulsheets.com
Data made simple, spreadsheets reimagined
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives