Filter condition in CDC

[sush_1]

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

[john_wang]

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.

[sush_1]

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

[john_wang · Accepted solution]

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.

[DesmondWOO]

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