XML: Write the result of a loop in the same line in tMap (csv file out put)

[Anonymous]

Hello,

I have an XML file that contains people with their Name, and their function, and I have to retrieve their function in the same line in a tmap (the output is a CSV file),
With a loop in the input XML file I get each person in a line but I want to retrieve them in the same line

See screenshots:

Ex: file from XML input:

        

Can you help me to solve this problem and tell me what should I use as a component please?

Thanks for your help

[Anonymous]

Hi,

    Once you parse the data out of XML using tXMLmap, pass the output to a tdenormalize component

    Please refer the link below for details of component and sample scenarios.

https://help.talend.com/reader/jomWd_GKqAmTZviwG_oxHQ/K4daeny9X_pgAhOiBR~Kug

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂