2 Replies Latest reply on Jun 17, 2013 3:39 PM by MW Design

    How to repeat data with Data Merge?


      How can I repeat data in the same text block with Data Merge? I have an Excel file with a class schedule that I need to import but when I use Data Merge, it wants to create a new page for each line. I want to keep the data in one text block per page and use Data Merge so when I get the new Excel file, it will be easy to update. This seems like it would be a simple thing to do, but I can't find the answer. Can anyone help?

        • 1. Re: How to repeat data with Data Merge?
          Peter Spier Most Valuable Participant (Moderator)

          Data Merge does a single frame for each record. It sounds like you've got it set also to do a single record per page, but you can do multiple records, but each record will remain in its own frame.


          I think you may have better luck placing the Excel table directly. You can link it so it updates when the file changes, but unless you use table and cell styles you will lose any formatting you apply ing ID when you do an update.

          • 2. Re: How to repeat data with Data Merge?
            MW Design Level 5

            Time for me to sound like a broken record. Data merge could be used for this but I don't think it was ever intended for such recurring publications like you are making. There will always be a lot of repetitive work that always will need to be performed after each update.


            Instead, I think you should read up on using an XML workflow. Now, the XML out of excel needs transformed to be viable inside ID. But that is reasonably easy and can be done in an XML editor or upon importing into ID. Though it has been set aside for a time, I am making an example of a college course catalog for a customer. I'll see if I can finish it off by the weekend. If so, I'll post it to this thread.


            Take care, Mike