SQL Merge results in UPSERT settings

[KellyHobson]

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

• Qlik Replicate 

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.