How do you merge 2 documents? Each document has one sheet, so I'd like to merge the 2 in one document containing 2 sheets.
I don't think that is possible in any simple way.
1. Do both documents contain the same script with data? Otherwise move from one to the other so that it is complete.
2. Create a new sheet. Go to the second document and select all objects in the sheet (ctrl+a), copy and paste in the first document.
Great. That should do it. I'll just make sure to inspect the field names so joins are created appropriately between the two.
Ah, now I see that you have posted in Server/Publisher, so maybe you mean when distribution? Still dont think there is any simple way.
Another way of course is to keep two documents but have a button that opens the other document and keep selections (if field names are identical).
Retrieving data ...