How to implement "soft" deletes on replicated table

[OritA]

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/Custom...

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

[Dana_Baldwin]

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/Custom...

[kishetty03]

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

[Sonja_Bauernfeind]

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