I have SALES table with millions of records, and SALES_ORG table that has sales reps, their managers, etc. Once a record is updated in SALES_ORG table, I need to update all records with new values in SALES table. Here is a simple SQL Update query that accomplishes this perfectly:
UPDATE A
SET SR_NAME = B.SR_NAME,
SM_NAME = B.SM_NAME,
DIR_NAME = B.DIR_NAME
FROM DM.SALES A
INNER JOIN DM.SALES_ORG B ON A.CUST_ID = B.CUST_ID;
Database is SAP HANA if that matters.
I've looked everywhere, and I can't figure out a way to do it in Alteryx without having to create a temporary table, which is not feasible. I have a scheduled workflow that loads SALES_ORG, and would like to add the update process to the workflow. Thanks for any help!
