Running pure update on SQL table

[dralban]

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!

[AZuc · Accepted solution]

@dralban , take a look on these links

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Alteryx-Pre-Post-SQL-Statements/ta-...

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-do-I-execute-a-sql-update-statemen...

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Can-you-execute-generic-SQL-commands/t...