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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
A_C
Contributor
Contributor

Refresh/update data and add new data to existing QVD file

Hi Community,

I was wondering what the script would be for me to continue to add new data daily and update/refresh my data from these same tables within the data-warehouse based on a scheduler? I am using a DB2 database connection. I am somewhat familiar with the append syntax, but cannot seem to get it to work. Here is my current script: 

LOAD
NATL_ACCT_NO WHERE NATL_ACCT_NO = '105591';

[ACCOUNT_GROUP_MODEL]:

SELECT
"NATL_ACCT_NO"
FROM "WHSE"."ACCOUNT_GROUP_MODEL";

LOAD MI_LOC as "BR",
CUSTOMER_NO as "Cust Num",
SHIPPER_CTL_NO as "Inv No",
SHIP_TO_CUST_NO as "BR Customer Acct #",
BRANCH_NAME as "BR Name",
INVOICE_DATE as "Inv Date";

[SALES_USAGE]:
SELECT "MI_LOC",
CUSTOMER_NO,
SHIPPER_CTL_NO,
SHIP_TO_CUST_NO,
BRANCH_NAME,
INVOICE_DATE,

FROM "WHSE"."SALES_USAGE";

2 Replies
m_woolf
Master II
Master II

A_C
Contributor
Contributor
Author

Thanks for the reply Mwoolf, however it was not quite what I was looking for. It did give me some insight and direction of where to start but I still cannot seem to get it. Is there an append function that basically adds new data to my qvd without reloading all the unchanged data in as well? I am also operating in qlik sense desktop and those formats seem to have a different approach.