Alteryx Designer Desktop Discussions

dralban · ‎11-02-2021

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!