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

Margaret P

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.

CPorthouse

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.

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

Community-Pasted-Attachment-1701738361315.png

Community-Pasted-Attachment-1701738372594.png