SQL Server Transactional Replication - Updates Only

[Praveen_Devaram]

With native SQL Server transactional replication, you can turn off insert/udpate/delete in the article properties > statement delivery section.

Is there similar functionality with Qlik?

I'd like to create a task where it will only capture updates for a specific table.

[Dana_Baldwin · Accepted solution]

Hi @Praveen_Devaram 

This section in the user guide should help: Creating a record selection condition for one or more columns #Creating a record selection condition...

[john_wang]

Hello @Praveen_Devaram ,

@Dana_Baldwin 's solution works however I still want to understand further about the task design: if capture UPDATE only, then how about the INSERT records? if all the INSERT operations are ignored, the target UPDATE maybe failed as the INSERT row cannot replicated to target side, then the UPDATE operation cannot find the target row, unless the task set to UPSERT Mode, or Store Changes Mode. So far we still need replicate the INSERT and DELETE operations to make sure the data synchronization between source and target side.

Regards,
John.