When you start the merge, under the Records tab > Records to merge, do you have single record or a specified range selected?
Thank you for your reponse, no I didn't have multiple records checked but after checking multiple records datamerge places each day on a separate page.
Data Merge is finicky when doing multiple record merges. You must use EXACTLY ONE set of field placeholders and leave the rest of the page blank so ID can duplicate the records according to the spacing you set up. Keep in mind that ID ID is going to duplicate everything, even stray marks, so you want to set up in such a way that the bounding box surrounding everything on the page actually small enough to fit multiple times. It often helps if you draw some guides to establish the grid, then lay out everything in the upper left position, and finally draw a no-fill/no-stroke frame around it that snaps to the surrounding guides and group everything. This allows you to set your spacings to 0 and know that the finished merge will follow the grid.
Is the OP trying to get the records so that all the results flow into the one text box? e.g. in microsoft word, there is the ability to merge to a catalogue, which WOULD allow:
and so on.
that won't work in indesign... without a third party plug-in at least - it won't work with indesign "off the shelf".
the way data merge works in indesign is it "plops" data where its told to. if a textbox has the fields:
record one may look like:
monday, 16 january 19th hole
but that's it. record two may look like:
tuesday, 17 january hangover
but getting the two records together (e.g. so the next record is directly underneath) won't happen in data merge using indesign.
indesign CAN do multiple records - don't misunderstand me, BUT it won't put them into the same text box. during the data merge output, the option to make multiple records literally steps and repeats whatever indesign sees on the page and "steps and repeats" it according to values based in the rows and columns of that dialog box AND the size of all items currently on the indesign page which have to be repated (so if everything is selected on the page, it will duplicate from the top left item to the bottom right item).
HOWEVER, i think an alternative would be an XML based solution, but the learning curve is steep. It will put all the repeating data in the same text frame though. no really good resources out there devoted to both XML and indesign except for a book called "A Designer's Guide to Adobe InDesign and XML" by James J Maivald.
There are two aspects of Records in datamerge.
The first: Records to Merge pertains to selecting what info from the data source you would like to use in the merge. A row in your spread sheet = a record, and you can select all, one, or a range of records.
The second: Records per Document Page: either single or multiple. This pertains to the process after ID populates the variable fields. Each collection of data is considered a record, and one record can be place on one page. Or many records placed on one page.
My question was in regards to Records to Merge which in your situation, a single record could have been selected, preventing any additional records to be merged.
An additional thought... In the event that all records was selected and only one record was merged... A lot of times the data source may contain a bogus character that prevents data merges from happening. Inspect the raw .csv file and see if there are any suspected characters. Also, try a .txt file for the data source.