I'm a heavy SQL user and have been using SSIS to push data to our SQL Staging tables. The Staging tables are compared to the Production tables to see what records have been updated, deleted, or brand new. I use the SQL MERGE statement to do this. Can someone explain to me a high-level proof-of-concept workflow of achieving this within Alteryx? I'm still very new to Alteryx and trying to understand its capabilities.
Possible that I misunderstood something, but would the option below not perform the action you're looking for? This is from a standard "Output Data" tool, not the "Write In-DB". The Update options do rely that your table contain PK's.