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