<?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 Loading tables from one QVW to another QVW without using binary load in App Development</title>
    <link>https://community.qlik.com/t5/App-Development/Loading-tables-from-one-QVW-to-another-QVW-without-using-binary/m-p/2472136#M99754</link>
    <description>&lt;P&gt;I have a source qv app which is UI layer. It is getting data using binary load from data model.&lt;/P&gt;
&lt;P&gt;Source app name: Source.qvw; last refreshed on Dec 2023.&lt;/P&gt;
&lt;P&gt;Data model app name: DM.qvw&lt;/P&gt;
&lt;P&gt;Script in Source app: Binary [../Path/DM.qvw];&lt;/P&gt;
&lt;P&gt;In source app, I have data as of Dec 2023. And in Latest DM, I have data as of June 2024.&lt;/P&gt;
&lt;P&gt;Now, I want to store the data from Source.qvw into QVDs without loading latest DM.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;I used below script:&lt;/P&gt;
&lt;P&gt;&lt;FONT color="#FF9900"&gt;Binary [../Path/DM.qvw];&lt;/FONT&gt;&lt;/P&gt;
&lt;P&gt;&lt;FONT color="#FF9900"&gt;FOR vCount = 0 to NoOfTables()-1&lt;/FONT&gt;&lt;/P&gt;
&lt;P&gt;&lt;FONT color="#FF9900"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; LET vTableName = TableName($(vCount));&lt;/FONT&gt;&lt;/P&gt;
&lt;P&gt;&lt;FONT color="#FF9900"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; STORE $(vTableName) INTO $(vTableName).qvd (qvd);&lt;/FONT&gt;&lt;/P&gt;
&lt;P&gt;&lt;FONT color="#FF9900"&gt;NEXT vCount&lt;/FONT&gt;&lt;/P&gt;
&lt;P&gt;&lt;FONT color="#000000"&gt;But, this will fetch latest data as we are loading DM again. I want to load the existing data of tables from source.qvw into QVDs.&lt;/FONT&gt;&lt;/P&gt;
&lt;P&gt;&lt;FONT color="#000000"&gt;Can someone help me in this?&lt;/FONT&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Fri, 15 Nov 2024 20:54:27 GMT</pubDate>
    <dc:creator>bharadwajk96</dc:creator>
    <dc:date>2024-11-15T20:54:27Z</dc:date>
    <item>
      <title>Loading tables from one QVW to another QVW without using binary load</title>
      <link>https://community.qlik.com/t5/App-Development/Loading-tables-from-one-QVW-to-another-QVW-without-using-binary/m-p/2472136#M99754</link>
      <description>&lt;P&gt;I have a source qv app which is UI layer. It is getting data using binary load from data model.&lt;/P&gt;
&lt;P&gt;Source app name: Source.qvw; last refreshed on Dec 2023.&lt;/P&gt;
&lt;P&gt;Data model app name: DM.qvw&lt;/P&gt;
&lt;P&gt;Script in Source app: Binary [../Path/DM.qvw];&lt;/P&gt;
&lt;P&gt;In source app, I have data as of Dec 2023. And in Latest DM, I have data as of June 2024.&lt;/P&gt;
&lt;P&gt;Now, I want to store the data from Source.qvw into QVDs without loading latest DM.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;I used below script:&lt;/P&gt;
&lt;P&gt;&lt;FONT color="#FF9900"&gt;Binary [../Path/DM.qvw];&lt;/FONT&gt;&lt;/P&gt;
&lt;P&gt;&lt;FONT color="#FF9900"&gt;FOR vCount = 0 to NoOfTables()-1&lt;/FONT&gt;&lt;/P&gt;
&lt;P&gt;&lt;FONT color="#FF9900"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; LET vTableName = TableName($(vCount));&lt;/FONT&gt;&lt;/P&gt;
&lt;P&gt;&lt;FONT color="#FF9900"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; STORE $(vTableName) INTO $(vTableName).qvd (qvd);&lt;/FONT&gt;&lt;/P&gt;
&lt;P&gt;&lt;FONT color="#FF9900"&gt;NEXT vCount&lt;/FONT&gt;&lt;/P&gt;
&lt;P&gt;&lt;FONT color="#000000"&gt;But, this will fetch latest data as we are loading DM again. I want to load the existing data of tables from source.qvw into QVDs.&lt;/FONT&gt;&lt;/P&gt;
&lt;P&gt;&lt;FONT color="#000000"&gt;Can someone help me in this?&lt;/FONT&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Fri, 15 Nov 2024 20:54:27 GMT</pubDate>
      <guid>https://community.qlik.com/t5/App-Development/Loading-tables-from-one-QVW-to-another-QVW-without-using-binary/m-p/2472136#M99754</guid>
      <dc:creator>bharadwajk96</dc:creator>
      <dc:date>2024-11-15T20:54:27Z</dc:date>
    </item>
    <item>
      <title>Re: Loading tables from one QVW to another QVW without using binary load</title>
      <link>https://community.qlik.com/t5/App-Development/Loading-tables-from-one-QVW-to-another-QVW-without-using-binary/m-p/2472221#M99759</link>
      <description>&lt;P&gt;Same loop but binary load Source.qvw instead of DM.qvw.&lt;/P&gt;
&lt;P&gt;&lt;FONT face="courier new,courier"&gt;&lt;SPAN&gt;Binary [../Path/source.qvw]&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Here's a generalized tool to store the tables from any qvw.&amp;nbsp;&lt;A href="https://qlikviewcookbook.com/tools/#squelch-taas-accordion-shortcode-content-10" target="_blank"&gt;https://qlikviewcookbook.com/tools/#squelch-taas-accordion-shortcode-content-10&lt;/A&gt;&lt;/P&gt;
&lt;P&gt;-Rob&lt;/P&gt;</description>
      <pubDate>Tue, 23 Jul 2024 00:59:13 GMT</pubDate>
      <guid>https://community.qlik.com/t5/App-Development/Loading-tables-from-one-QVW-to-another-QVW-without-using-binary/m-p/2472221#M99759</guid>
      <dc:creator>rwunderlich</dc:creator>
      <dc:date>2024-07-23T00:59:13Z</dc:date>
    </item>
  </channel>
</rss>

