I have a Flat File with an ID and variable occurrence of comments:
I am looking to combine the rows by the ID and concatenate the corresponding Comment values on the output Flat File delimited by a semi-colon:
I've tried converting the FF to an XML so I can group the Comments alongside the same ID, I got as far as getting the following XML output:
When I try to map the above back to a Flat File - I use a Concat function to join the comments for the same ID, but I guess the parser doesn't see all the comments at once an the output is broken out by comment still.
Here is the Process:
Do I need a custom script to concatenate the multiple comments on the output? Or have I over thought this - and there is an easier way of achieving what I need.