Refresh/update data and add new data to existing QVD file
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';
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";
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.