article How to implement "soft" deletes on replicated table in Official Support Articles

How to implement "soft" deletes on replicated table

OritA — Thu, 27 Jun 2024 18:02:53 GMT

In general - "soft delete" is a term used when a delete operation is performed on a row of a table and you do not want that the row will be physically deleted. In this case, instead of physically deleting the row, you set a flag that indicates that the row has been deleted.

In Replicate, it is possible to implement "soft deletes" on a replicated table using 'operation_indicator' function used in a transformation rule defined on the requested table.

Details on 'operation_indicator' function can be found in the Replicate Users guide under:

Customizing tasks --> Using the Expression Builder --> Using elements in the Expresson Builder --> Functions --> Operations

https://help.qlik.com/en-US/replicate/May2022/Content/Global_Common/Content/SharedEMReplicate/Customize%20Tasks/tasks_expressOther.htm#Operation

Attached is an example for implementing "soft deletes" on a replicated table.

Re: How to implement "soft" deletes on replicated table

Dana_Baldwin — Thu, 14 Jul 2022 23:04:01 GMT

Here is the link to the section of the User Guide referenced above:
https://help.qlik.com/en-US/replicate/May2022/Content/Global_Common/Content/SharedEMReplicate/Customize%20Tasks/tasks_expressOther.htm#Operation

Re: How to implement "soft" deletes on replicated table

kishetty03 — Thu, 25 Apr 2024 09:01:00 GMT

Does this work while replicating Data from S/4 Hana to Google Bigquery??

Re: How to implement "soft" deletes on replicated table

Sonja_Bauernfeind — Fri, 26 Apr 2024 08:59:41 GMT

Hello @kishetty03

I recommend posting your query directly in our Qlik Replicate forum to engage with your knowledgeable Qlik peers and our active support engineers. When posting, include as much detail about your requirement as possible.

We also invite you to make use of our chat function if you require more direct assistance or a case to be logged.

All the best,
Sonja