Replicate - How to filter records by using before-image data

[john_wang]

Sometimes we need to to prevent unchanged data in selected columns to be replicated. For example we want to replicate the changed rows which is:

1- it's INSERT or DELETE operation, or

2- it's UPDATE operation but only if the column SALARY value is changed (if other columns values are changed then the rows will be ignored).

Environment

• Qlik Replicate All supported versions

Detailed steps:

1. Open table setting

2. Go to "Filter" tab

3. In the Expression Builder

($BI__SALARY != $SALARY) OR ( $AR_H_OPERATION <> 'UPDATE')

Related Content

before-image data can be stored in target table, see sample here .

Qlik Replicate