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

One Star

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

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:


        xml_personnes.PNGtmap_loop.PNGcsv_sortie.PNG

 

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

 

Thanks for your help

Employee

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

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 :-)

 

 

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog

Why Companies Move to the Cloud: 7 Success Stories

Learn how and why companies are moving to the Cloud

Read Now