tFileInputDelimited --> tXMLMap --> TXMLOutput
CSV file structure:
ParticipantID Gender Participation
505 Male Open
506 Female Closed
Desired XML output for Row 2 of CSV (1 XML file per row):
<ID> <key>ParticipantID</key> <value>505</value> </ID> <Gender>Male</Gender> <Participation> <ParticipationType>OPEN</ParticipationType> </Participation>
In Talend Integration, how do I nest?
- "<value>505</value>" within ParticipantID and ID tags
- "<ParticipationType>OPEN</ParticipationType>" within Participation tag
Thanks for your help.
@Astrocyte - I would recommend to use tAdvancedFileOutputXML to make your output in the desired XML format.
Job Layout -
XML tree configuration -
Watch the recorded webinar!
Create systems and workflow to manage clean data ingestion and data transformation.
Introduction to Talend Open Studio for Data Integration.
Test drive Talend's enterprise products.