topic Finding duplicates in a change table in Qlik Replicate

Finding duplicates in a change table

MoeE — Wed, 26 Feb 2025 05:53:01 GMT

Hi,

We have a scenario where a change table missed some records a couple of weeks back. Fortunately, we have the option to resume from a timestamp in order to recover those records. The issue with this is that the changes are going to be replayed thus causing duplicates in the change table. (This is a change table only task btw)

In order to identify duplicates in the change table, is there a recommended way to do so? So far in my testing, I've identified the column header__stream_position, which looks like it should be unique for each change in the table. Can I use that to identify duplicates?

Help with this is greatly appreciated as always. Thank you.

Re: Finding duplicates in a change table

john_wang — Sat, 01 Mar 2025 14:30:40 GMT

Hello @MoeE ,

You are right. The column header__stream_position is the only column can be used to identify a unique row in Change Table.

Regards,

John.

Re: Finding duplicates in a change table

MoeE — Sun, 02 Mar 2025 22:16:30 GMT

Hi John,

Thanks for the assistance as always. Have a good day.

Regards,

Mohammed

Re: Finding duplicates in a change table

john_wang — Mon, 03 Mar 2025 01:08:16 GMT

Thank you so much for your great support Mohammed @MoeE !