Datamesh - way to transfer only parent row to sheet?
I'm currently experiencing an issue when I try to DataMesh a Pivot Table to an existing spreadsheet. My Pivot Table is my Source Sheet, and I use the existing spreadsheet as my Target Sheet.
The Pivot Table is set up where each row I need copied into the existing spreadsheet has a Parent Row (a number) and a Child row (a description for the number).
When I try to DataMesh the Pivot Table into the existing spreadsheet, the DataMesh carries over both the parent & child rows, although I only need the parent row carried over. I have the DataMesh set to "copy and add new", as the Pivot Tables will be adding new numbers/descriptions throughout the year, and I'd like for the DataMesh to capture the new rows.
Is there a way to prevent the child row from being carried over without changing the "copy and add new" data mapping format option?
This is my first time using DataMesh, so any guidance is greatly appreciated!