Data Merge multiple records not working properly at all
Data Merge is very buggy on latest update, makes tool useless:
1/ repeating same record over (with multiple records)
2/ records are not imported in order of source document
3/ preview and results do not match (alignment, records, etc)
tested with both txt and csv
Ross Gilder commented
I have this issue too, the preview generates the correct, and wanted data merge result but when executing the final data merge, it seems to reuse an entry at random.
As per Jolene's comment, creating a brand new document does fix this issue temporarily, but this is not a particularly efficient work around.
Jolene Carlier commented
This keeps being a problem for me, I have now discovered though that (at least sometimes) the problem seems solved (for a moment) when you create a whole new document, either paste, or otherwise recreate the table (or whatever) in which you want to data merge. I think you should not yet put it in a new master page, but just on the first page you get in front of you and do the whole thing again. Give it a try. Its a hassle for sure, but it makes it a bit better, next time I'll immediately do / try that.