<?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 How to load XML tags that do not require source loop to snowflake in Talend Studio</title>
    <link>https://community.qlik.com/t5/Talend-Studio/How-to-load-XML-tags-that-do-not-require-source-loop-to/m-p/2335849#M104362</link>
    <description>&lt;P&gt;I have tXMLMap component where I would want to load few fields to be loaded onto Snowflake table.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;As seen in the below snapshot, I would want CompanyData fields to be loaded to a table once and fields on the Response tag to be run on loop and loaded to another Snowflake table.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="0695b00000Dv4yaAAB.png"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/151839i527FA0000D87FF07/image-size/large?v=v2&amp;amp;px=999" role="button" title="0695b00000Dv4yaAAB.png" alt="0695b00000Dv4yaAAB.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;However, the Talend Designer shows an error message &lt;B&gt;Errors: header have no source loops&lt;/B&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="0695b00000Dv4yfAAB.png"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/145582i2FA9ECE14AF39C1C/image-size/large?v=v2&amp;amp;px=999" role="button" title="0695b00000Dv4yfAAB.png" alt="0695b00000Dv4yfAAB.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;How to fix this error when we do not want a particular XML tag to run on a loop? When I test ran the job from Designer Console, the job completed. But am worried if this will throw an error once deployed on the Talend server. Please advise.&lt;/P&gt;</description>
    <pubDate>Sat, 16 Nov 2024 00:18:57 GMT</pubDate>
    <dc:creator>vvazza10</dc:creator>
    <dc:date>2024-11-16T00:18:57Z</dc:date>
    <item>
      <title>How to load XML tags that do not require source loop to snowflake</title>
      <link>https://community.qlik.com/t5/Talend-Studio/How-to-load-XML-tags-that-do-not-require-source-loop-to/m-p/2335849#M104362</link>
      <description>&lt;P&gt;I have tXMLMap component where I would want to load few fields to be loaded onto Snowflake table.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;As seen in the below snapshot, I would want CompanyData fields to be loaded to a table once and fields on the Response tag to be run on loop and loaded to another Snowflake table.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="0695b00000Dv4yaAAB.png"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/151839i527FA0000D87FF07/image-size/large?v=v2&amp;amp;px=999" role="button" title="0695b00000Dv4yaAAB.png" alt="0695b00000Dv4yaAAB.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;However, the Talend Designer shows an error message &lt;B&gt;Errors: header have no source loops&lt;/B&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="0695b00000Dv4yfAAB.png"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/145582i2FA9ECE14AF39C1C/image-size/large?v=v2&amp;amp;px=999" role="button" title="0695b00000Dv4yfAAB.png" alt="0695b00000Dv4yfAAB.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;How to fix this error when we do not want a particular XML tag to run on a loop? When I test ran the job from Designer Console, the job completed. But am worried if this will throw an error once deployed on the Talend server. Please advise.&lt;/P&gt;</description>
      <pubDate>Sat, 16 Nov 2024 00:18:57 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/How-to-load-XML-tags-that-do-not-require-source-loop-to/m-p/2335849#M104362</guid>
      <dc:creator>vvazza10</dc:creator>
      <dc:date>2024-11-16T00:18:57Z</dc:date>
    </item>
    <item>
      <title>Re: How to load XML tags that do not require source loop to snowflake</title>
      <link>https://community.qlik.com/t5/Talend-Studio/How-to-load-XML-tags-that-do-not-require-source-loop-to/m-p/2335850#M104363</link>
      <description>&lt;P&gt;I guess you can tag 'company info'  as the loop element. From the little that i can seen in your snippet, Company Info is at the header level and will not be repeating, so you are good to use it as a dummy loop element.&lt;/P&gt;</description>
      <pubDate>Mon, 05 Apr 2021 21:21:40 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/How-to-load-XML-tags-that-do-not-require-source-loop-to/m-p/2335850#M104363</guid>
      <dc:creator>tnewbie</dc:creator>
      <dc:date>2021-04-05T21:21:40Z</dc:date>
    </item>
  </channel>
</rss>

