Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE

How to implement "soft" deletes on replicated table

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
OritA
Support
Support

How to implement "soft" deletes on replicated table

Last Update:

Jul 30, 2021 9:11:16 AM

Updated By:

OritA

Created date:

Jul 30, 2021 9:11:16 AM

Attachments

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 

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

Comments
Dana_Baldwin
Support
Support

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
Contributor III
Contributor III

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

Sonja_Bauernfeind
Digital Support
Digital Support

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

Contributors
Version history
Last update:
‎2021-07-30 09:11 AM
Updated by: