Is it possible to export multiple summaries to same worksheet?

Al_22614

Hello Monarch SMEs:

I would like to export two Summaries from two different Monarch Models to the same Excel Workseet usind .  I have attached an example of the Excel file (Summary_Export.xlsx), containing one WorkSheet (Multiple_Summaries).

I have identified on summary as Summary_1, which has 7 data columns and the other summary is Summary _2, which contains 7 different data columns.  By having both summaries on the same worksheet will facilitate analysis.  Unfortunately I could not create a join to link the two data sources together. 

I was thinking if I a Worksheet with all 14 data columns already existing in the Excel worksheet, then I could export the first 7 columns (Summary_1) from the first Monarch Model and append the data under the first 7 columns.  Then would export the second 7 columns (Summary_2) from the second Monarch Model and append the data under the second 7 columns. 

Hopefully there is an easy solution which I have not thought of.

Thanks in advance for you help...

Al

 

Summary_Export.xlsx

Al_22614

I got answer I needed (below):

2021-10-19 16:06:46 EDT - Paulo Gonzales^{Additional comments}

Hello Al,

Thank you for reaching technical support.

Monarch can't export summaries or tables on the same worksheet if they don't have the same set of columns. You can only export to the same excel file but you'll need to create a new worksheet if the other table have different set of columns.

let me know if you have other concern.

 

Thank you,

Altair Support Team