QLIK REPLICATE - filtering out certain operations from the change tables

[edward221096]

Hi Everyone

We would like to know how to exclude certain operations from being added to the change table.

Example
1. In Table A, a row was deleted, and the DELETE operation should not be included in the change table.
2. In Table B, a row was inserted, and the INSERT operation will be shown on the change table.

Previously we used Attunity studio to do this, however, we would like to know if this is possible within Qlik Replicate.

Thanks,

[Steve_Nguyen · Accepted solution]

@edward221096

1. when your refer to the change table, i am assume that your task is set for Store changes, and the default table is __CT .

if that is the case, you can not exclude operation from the changes tables . 

2. if you looking for soft delete , look at article below:

https://community.qlik.com/t5/Knowledge/How-to-implement-quot-soft-quot-deletes-on-replicated-table/...

[Alan_Wang · Accepted solution]

Hi Edward, 

I suggest setting another replication task and filtering out [header__]change_oper with 'D' values to exclude deletes. This involves another task, but you will be able to customize the table to what you need.

[Heinvandenheuvel]

Hmm, can you not setup relatively simple per table filters using "$AR_H_OPERATION"

Check userguide, search for AR_H_OPERATION for examples.

Hein.

[Michael_Litz · Accepted solution]

Here is a link to an article on a couple of ways to filter operations:

https://community.qlik.com/t5/Knowledge/Filter-Deletes-in-Replicate/ta-p/1801945

Michael Litz

[Bill_Steinagle · Accepted solution]

Edward,

Hello thank you for the post to the QDI forums. As per the use of the Header Columns you can set a case statement on the Column as shown and check the AR_H_OPERATION and how to continue processing the row on the check as shown in below example. Here is a simple CASE statement to filter out certain types of operations on the given Table/Column/Row

CASE WHEN $AR_H_OPERATION = 'INSERT' THEN $column END

Thanks!

Bill