Skip to main content
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.