<?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 Get nodes (not just strings) in tFileInputMSXML in Talend Studio</title>
    <link>https://community.qlik.com/t5/Talend-Studio/Get-nodes-not-just-strings-in-tFileInputMSXML/m-p/2201776#M3730</link>
    <description>Is there a way in the tFileInputMSXML component to retrieve nodes, i.e. whole subtrees, in a column of type Document?&lt;BR /&gt;I have a large XML file that is not only multi-schema, but also nested in multiple (=4-5) levels. I got tFileInputMSXML running to loop at any required nesting level and parse all the schemata I want. However, I have 100-200 schemata I need to parse altogether, so parsing them with a single tFileInputMSXML component seems not to be a good idea in terms of job design.&lt;BR /&gt;Therefore, I would like to parse upper nodes into their corresponding schemata, while preserving their child nodes as Documents. This way, I can delay the processing of the child nodes into subsequent components like tExtractXMLField and thus handle complexity by not having to parse all of the 100-200 different schemata at once inside a single tFileInputMSXML component.&lt;BR /&gt;What can I do?&lt;BR /&gt;What I have tried so far:&lt;BR /&gt;1. The tutorial (&lt;A href="https://help.talend.com/search/all?query=tFileInputMSXML&amp;amp;content-lang=en" target="_blank" rel="nofollow noopener noreferrer"&gt;https://help.talend.com/search/all?query=tFileInputMSXML&amp;amp;content-lang=en&lt;/A&gt;) selects a node with multiple children, but only outputs them as a string (see my comment at the bottom of the page).&lt;BR /&gt;2. The (non-multischema) tFileInputXML component has a "Get nodes" option for this case, but the tFileInputMSXML component has not.</description>
    <pubDate>Tue, 03 Dec 2013 11:09:13 GMT</pubDate>
    <dc:creator>Anonymous</dc:creator>
    <dc:date>2013-12-03T11:09:13Z</dc:date>
    <item>
      <title>Get nodes (not just strings) in tFileInputMSXML</title>
      <link>https://community.qlik.com/t5/Talend-Studio/Get-nodes-not-just-strings-in-tFileInputMSXML/m-p/2201776#M3730</link>
      <description>Is there a way in the tFileInputMSXML component to retrieve nodes, i.e. whole subtrees, in a column of type Document?&lt;BR /&gt;I have a large XML file that is not only multi-schema, but also nested in multiple (=4-5) levels. I got tFileInputMSXML running to loop at any required nesting level and parse all the schemata I want. However, I have 100-200 schemata I need to parse altogether, so parsing them with a single tFileInputMSXML component seems not to be a good idea in terms of job design.&lt;BR /&gt;Therefore, I would like to parse upper nodes into their corresponding schemata, while preserving their child nodes as Documents. This way, I can delay the processing of the child nodes into subsequent components like tExtractXMLField and thus handle complexity by not having to parse all of the 100-200 different schemata at once inside a single tFileInputMSXML component.&lt;BR /&gt;What can I do?&lt;BR /&gt;What I have tried so far:&lt;BR /&gt;1. The tutorial (&lt;A href="https://help.talend.com/search/all?query=tFileInputMSXML&amp;amp;content-lang=en" target="_blank" rel="nofollow noopener noreferrer"&gt;https://help.talend.com/search/all?query=tFileInputMSXML&amp;amp;content-lang=en&lt;/A&gt;) selects a node with multiple children, but only outputs them as a string (see my comment at the bottom of the page).&lt;BR /&gt;2. The (non-multischema) tFileInputXML component has a "Get nodes" option for this case, but the tFileInputMSXML component has not.</description>
      <pubDate>Tue, 03 Dec 2013 11:09:13 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/Get-nodes-not-just-strings-in-tFileInputMSXML/m-p/2201776#M3730</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2013-12-03T11:09:13Z</dc:date>
    </item>
    <item>
      <title>Re: Get nodes (not just strings) in tFileInputMSXML</title>
      <link>https://community.qlik.com/t5/Talend-Studio/Get-nodes-not-just-strings-in-tFileInputMSXML/m-p/2201777#M3731</link>
      <description>Hi, &lt;BR /&gt;What is the structure of your document? Is it possible to paste it on forum?&lt;BR /&gt;Best regards&lt;BR /&gt;Sabrina</description>
      <pubDate>Wed, 04 Dec 2013 04:00:41 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/Get-nodes-not-just-strings-in-tFileInputMSXML/m-p/2201777#M3731</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2013-12-04T04:00:41Z</dc:date>
    </item>
  </channel>
</rss>

