Data Mesh Error
Hi, I am using Data Mesh for the first time. I am trying to populate my target sheet with a report. There is a sheet that feeds the report. New rows may be added and existing rows will be edited frequently. So, I believe choosing "Copy and Add Data" is the correct choice for Data Mapping Format. I have 2 rows in the target sheet that would not be in the source report. They are formulas needed for the incoming data...I initially tried the data mesh process where I only had those 2 rows in the target sheet thinking when I run Data Mesh it will add all the rows for me. The metrics it shows you of how many rows will be added or affected is correct, but when I run it nothing happens to my target sheet. I then tried to copy all my Initiative Names (primary/look up value) in the target sheet thinking maybe I needed to have some "match" in the first run. That didn't work either. After running DM I went in and manually re-ran it thinking maybe it was the 1 hour frequency that was the issue. That did nothing as well. Anyone have any ideas to what I may be doing wrong? Thanks!