Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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