AnsweredAssumed Answered

How do I combine a multi-line csv back together and keep the line breaks? (5 lines per employee)

Question asked by GarethHughes8951 on Oct 8, 2015
Latest reply on Oct 8, 2015 by GarethHughes8951
I'm trying to build a CSV where the results for one employee are mapped over 5 lines.
I have built a CSV profile with 5 child elements and done some mapping.
(I split per employee, map, combine. Normal stuff)
In debug, each Data Record looks perfect just before the combine. For each employee I have the 5 lines.
But the Combine steps puts all 5 lines onto 1 line and then that 1 line goes into the CSV.
E.g if I have 10 employees I want 50 lines, but get 10.

I have tried all the combinations of options in the Combine about headers and get the same results.
Ideas welcome before I break out the Groovy code.
I don't have the EDI option

Many thanks

Outcomes