<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic XML Parsing - data with XML tags in Talend Studio</title>
    <link>https://community.qlik.com/t5/Talend-Studio/XML-Parsing-data-with-XML-tags/m-p/2370617#M133643</link>
    <description>Hai, 
&lt;BR /&gt;I have an XML file as given below 
&lt;BR /&gt;&amp;lt;Data&amp;gt; 
&lt;BR /&gt; &amp;lt;mesg&amp;gt; 
&lt;BR /&gt; &amp;lt;MESGID&amp;gt;2958&amp;lt;/MESGID&amp;gt; 
&lt;BR /&gt; &amp;lt;CONTENT&amp;gt; 
&lt;BR /&gt; &amp;lt;alert&amp;gt; 
&lt;BR /&gt; &amp;lt;applnid&amp;gt;INT&amp;lt;/applnid&amp;gt; 
&lt;BR /&gt; &amp;lt;serviceid&amp;gt;ABC&amp;lt;/serviceid&amp;gt; 
&lt;BR /&gt; &amp;lt;requestid&amp;gt;876234&amp;lt;/requestid&amp;gt; 
&lt;BR /&gt; &amp;lt;date&amp;gt;27/01/2010&amp;lt;/date&amp;gt; 
&lt;BR /&gt; &amp;lt;format&amp;gt;pdf&amp;lt;/format&amp;gt; 
&lt;BR /&gt; &amp;lt;desc&amp;gt;STMT&amp;lt;/desc&amp;gt; 
&lt;BR /&gt; &amp;lt;status&amp;gt;success&amp;lt;/status&amp;gt; 
&lt;BR /&gt; &amp;lt;/alert&amp;gt; 
&lt;BR /&gt; &amp;lt;/CONTENT&amp;gt; 
&lt;BR /&gt; &amp;lt;/mesg&amp;gt; 
&lt;BR /&gt;&amp;lt;/Data&amp;gt; 
&lt;BR /&gt;Here MESGID and CONTENT are XML fields. But the CONTENT field has to be taken as it is with the xml tags given. 
&lt;BR /&gt;My Loop Xpath Query is "/Data" 
&lt;BR /&gt;and XPath query is "mesg/MESGID" and "mesg/CONTENT" 
&lt;BR /&gt;Now the values inside CONTENT are again parsed and only the values are given as output. 
&lt;BR /&gt;How do I get the entire content without parsing 
&lt;BR /&gt;Regards, 
&lt;BR /&gt;Amirths</description>
    <pubDate>Sat, 16 Nov 2024 13:32:52 GMT</pubDate>
    <dc:creator>Anonymous</dc:creator>
    <dc:date>2024-11-16T13:32:52Z</dc:date>
    <item>
      <title>XML Parsing - data with XML tags</title>
      <link>https://community.qlik.com/t5/Talend-Studio/XML-Parsing-data-with-XML-tags/m-p/2370617#M133643</link>
      <description>Hai, 
&lt;BR /&gt;I have an XML file as given below 
&lt;BR /&gt;&amp;lt;Data&amp;gt; 
&lt;BR /&gt; &amp;lt;mesg&amp;gt; 
&lt;BR /&gt; &amp;lt;MESGID&amp;gt;2958&amp;lt;/MESGID&amp;gt; 
&lt;BR /&gt; &amp;lt;CONTENT&amp;gt; 
&lt;BR /&gt; &amp;lt;alert&amp;gt; 
&lt;BR /&gt; &amp;lt;applnid&amp;gt;INT&amp;lt;/applnid&amp;gt; 
&lt;BR /&gt; &amp;lt;serviceid&amp;gt;ABC&amp;lt;/serviceid&amp;gt; 
&lt;BR /&gt; &amp;lt;requestid&amp;gt;876234&amp;lt;/requestid&amp;gt; 
&lt;BR /&gt; &amp;lt;date&amp;gt;27/01/2010&amp;lt;/date&amp;gt; 
&lt;BR /&gt; &amp;lt;format&amp;gt;pdf&amp;lt;/format&amp;gt; 
&lt;BR /&gt; &amp;lt;desc&amp;gt;STMT&amp;lt;/desc&amp;gt; 
&lt;BR /&gt; &amp;lt;status&amp;gt;success&amp;lt;/status&amp;gt; 
&lt;BR /&gt; &amp;lt;/alert&amp;gt; 
&lt;BR /&gt; &amp;lt;/CONTENT&amp;gt; 
&lt;BR /&gt; &amp;lt;/mesg&amp;gt; 
&lt;BR /&gt;&amp;lt;/Data&amp;gt; 
&lt;BR /&gt;Here MESGID and CONTENT are XML fields. But the CONTENT field has to be taken as it is with the xml tags given. 
&lt;BR /&gt;My Loop Xpath Query is "/Data" 
&lt;BR /&gt;and XPath query is "mesg/MESGID" and "mesg/CONTENT" 
&lt;BR /&gt;Now the values inside CONTENT are again parsed and only the values are given as output. 
&lt;BR /&gt;How do I get the entire content without parsing 
&lt;BR /&gt;Regards, 
&lt;BR /&gt;Amirths</description>
      <pubDate>Sat, 16 Nov 2024 13:32:52 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/XML-Parsing-data-with-XML-tags/m-p/2370617#M133643</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2024-11-16T13:32:52Z</dc:date>
    </item>
    <item>
      <title>Re: XML Parsing - data with XML tags</title>
      <link>https://community.qlik.com/t5/Talend-Studio/XML-Parsing-data-with-XML-tags/m-p/2370618#M133644</link>
      <description>hi 
&lt;BR /&gt;you can check on GetNodes check box in the mapping section of tFileInputXML component 
&lt;span class="lia-inline-image-display-wrapper" image-alt="0683p000009MACn.png"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/154443iC5B8CACEF3D12C6A/image-size/large?v=v2&amp;amp;px=999" role="button" title="0683p000009MACn.png" alt="0683p000009MACn.png" /&gt;&lt;/span&gt;</description>
      <pubDate>Thu, 22 Jul 2010 08:37:59 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/XML-Parsing-data-with-XML-tags/m-p/2370618#M133644</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2010-07-22T08:37:59Z</dc:date>
    </item>
  </channel>
</rss>

