XML Parsing - data with XML tags

Four Stars

XML Parsing - data with XML tags

Hai,
I have an XML file as given below
<Data>
<mesg>
<MESGID>2958</MESGID>
<CONTENT>
<alert>
<applnid>INT</applnid>
<serviceid>ABC</serviceid>
<requestid>876234</requestid>
<date>27/01/2010</date>
<format>pdf</format>
<desc>STMT</desc>
<status>success</status>
</alert>
</CONTENT>
</mesg>
</Data>
Here MESGID and CONTENT are XML fields. But the CONTENT field has to be taken as it is with the xml tags given.
My Loop Xpath Query is "/Data"
and XPath query is "mesg/MESGID" and "mesg/CONTENT"
Now the values inside CONTENT are again parsed and only the values are given as output.
How do I get the entire content without parsing
Regards,
Amirths
One Star yk
One Star

Re: XML Parsing - data with XML tags

hi
you can check on GetNodes check box in the mapping section of tFileInputXML componentSmiley Happy

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch