How to append additional data to an existing Monarch export file on a different tab.

Margaret P
Margaret P Altair Community Member
edited December 2023 in Community Q&A

I am having difficulty in Monarch classic with trying to append data to a new tab in an existing export file.  Are there any vidoes that show the process?  I have a report file that contains two slightly different layouts and so requires two different models to pull the data.  In a very old legacy Monarch vs. 11, by default, when the export file existing, adding data creating a separate tab in the same file was very easy to do.

Tagged:

Answers

  • CPorthouse
    CPorthouse
    Altair Employee
    edited December 2023

    If you are using Monarch Classic and Export Design, select the option for "When output files exist:" to "Add data to file".  You can change the next drop down "When output tables exist:" to either Overwrite table (which will overwrite a sheet with the same name), Add data to table (which will append if the schema is the same), or Skip table, which will not change the existing table.

    image

    If you are using "Create Export" instead of Export Design, select the same option:

    image

Categories