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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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
MVP
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