SQL Merge results in UPSERT settings

KellyHobson — Mon, 04 Apr 2022 17:15:53 GMT

Within Task Settings -> Change Processing, when you select 'Apply changes using SQL Merge', by default it will switch to UPSERT mode in the Apply Conflicts settings. The settings which are locked in or greyed out are still in effect.

No record is found on delete? -> Ignore record
Duplicate is observed on insert? -> Update the existing target record
No record is found on update? -> INSERT the missing target record

Prior setting:

Make the change to use SQL Merge:

Result:

Environment

The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.

article SQL Merge results in UPSERT settings in Official Support Articles

SQL Merge results in UPSERT settings

Environment