topic Filter condition in CDC in Qlik Replicate

Filter condition in CDC

sush_1 — Mon, 11 Nov 2024 05:38:39 GMT

Hi Team,

We have one table to be replicated while limiting a column to specific values.

E.g we want rows of columns CODE where values will be 'ANC' and 'MNC'

How should we add filter condition for this requirement.

Regards,

Sushant

Re: Filter condition in CDC

john_wang — Mon, 11 Nov 2024 05:51:31 GMT

Hello Sushant, @sush_1

Thanks for reaching out to Qlik Community!

There are three 'filter' functions in Qlik Replicate, depends on it takes effect in Full Load stage, or Change Processing stage, or both. Detailed description can be found in article https://community.qlik.com/t5/Qlik-Replicate/Pass-thru-filter/td-p/2411372 (see my comment).

Hope it helps.

John.

Re: Filter condition in CDC

sush_1 — Mon, 11 Nov 2024 06:14:03 GMT

Hi John,

Thanks for the your reply.

We want this condition to work in only CDC task . What should be the expression for this condition.

Regards

Sushant

Re: Filter condition in CDC

john_wang — Mon, 11 Nov 2024 06:52:14 GMT

Hi Sushant,

Thanks for the update. You may use the (2) Record Selection Condition, the expression sample:

In the above sample we need only the records which NAME equals "ABC", or "XYZ".

Hope this helps.

John.

Re: Filter condition in CDC

DesmondWOO — Mon, 11 Nov 2024 07:04:01 GMT

Hi @sush_1 ,

You may add a filter statement like this:
$CODE = 'ANC' OR $CODE = 'MNC'

However, please note that filters can only be applied to immutable columns. For example, if a user updates the value of CODE from 'AAA' to 'ANC' or from 'ANC' to 'AAA', it raises the question of whether Replicate should handle this.

Regards,
Desmond