Hello clinlab and welcome to the forum.
Your outline description reminds me of some reports that have been presented in the past for treatment as one large and long record.
However from your description do I understand correctly that you are using the 3 columns of information in the second section as you detail records with each 'data' (as shown in your illustration) being a separate detail record?
If so and if all the other sections are appends, headers or footers you will indeed see them attached to many detail records - possibly not the correct records either based on your outline and my reading of it, but that is for a separate discussion.
Bear in mind that if during the course of analysis you were to filter out some of the detail records you may still need the append information for your report, though of course large amounts of free text might always be of dubious value at that level. It might be worth thinking about different models for different purposes if you have conflicting analysis needs.
Subject to your answers to the above I will see if I can find something from the 'archives' that might give us a handle on the solution you need.
I will need to to another model and run
monarch twice. Once for each model.
I can do that. It's just a lot of extra work.
I still have a weird problem though
I set two different traps for headers. the detail
data being the same trap. Each header trap has
different fields, however when they get to the table
the trap data from the previous trap runs through the
data from the current trap. So its impossible
to tell which heading the detail belongs to. I
guess I could the multiple run thing, but I
was hoping to avoid it.
Any ideas why it just keeps duplcating? Flag or something
Creating a second model should not be too difficult and you could consider creating a batch file to run both of them at the same time if that is what you need to do.
For some of the other sort of similar examples back in time there was a way to extract most of the data as detail in a single pass but it could be that the reports are different enough to make that non viable.
I'm not sure I understand your duplicated data/traps problem. Each model can only produce the data fields defined in its templates. Are you then exporting the resulting tables?
Does the Model Info give any assistance to discovering where the fields come from? The Field List will certainly tell you the source template for each field.
Thanks for the help.
The only way i could show you is to post
the report file and resultant data.
Is there any way you know that I could post this on here
that would make sense to you? i could email it to you.
my email is (awilson25 at cfl.rr.com) i put it like that
to stop the web bots from grabbing it and adding me to the