Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
bharadwajk96
Contributor
Contributor

Loading tables from one QVW to another QVW without using binary load

I have a source qv app which is UI layer. It is getting data using binary load from data model.

Source app name: Source.qvw; last refreshed on Dec 2023.

Data model app name: DM.qvw

Script in Source app: Binary [../Path/DM.qvw];

In source app, I have data as of Dec 2023. And in Latest DM, I have data as of June 2024.

Now, I want to store the data from Source.qvw into QVDs without loading latest DM.

 

I used below script:

Binary [../Path/DM.qvw];

FOR vCount = 0 to NoOfTables()-1

     LET vTableName = TableName($(vCount));

     STORE $(vTableName) INTO $(vTableName).qvd (qvd);

NEXT vCount

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.

Can someone help me in this?

 

Labels (1)
1 Reply
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Same loop but binary load Source.qvw instead of DM.qvw.

Binary [../Path/source.qvw]

 

Here's a generalized tool to store the tables from any qvw. https://qlikviewcookbook.com/tools/#squelch-taas-accordion-shortcode-content-10

-Rob