topic Re: Replicating only few rows via filter without dropping and truncating the table? in Qlik Replicate

Replicating only few rows via filter without dropping and truncating the table?

Aegis — Thu, 31 Mar 2022 14:10:33 GMT

Hello, I'm wondering if its possible to replicate(update) only specific rows in the table without dropping and/or truncating the table?

Thanks ahead!

Re: Replicating only few rows via filter without dropping and truncating the table?

KellyHobson — Thu, 31 Mar 2022 14:19:17 GMT

Hey @Aegis ,

Within the expression builder, you can set up logic, expressions or functions based on SQLite to update records.

User Guide for reference:

https://help.qlik.com/en-US/replicate/May2021/Content/Global_Common/Content/SharedEMReplicate/Customize%20Tasks/task_expression_builder.htm

https://help.qlik.com/en-US/replicate/May2021/Content/Global_Common/Content/SharedEMReplicate/Customize%20Tasks/tasks_expressOther.htm

Best,

Kelly

Re: Replicating only few rows via filter without dropping and truncating the table?

KellyHobson — Thu, 31 Mar 2022 14:22:16 GMT

@Aegis here are a few examples from the Knowledge Base.

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

https://community.qlik.com/t5/Knowledge/Filter-for-last-90-days-of-data-in-Qlik-Replicate/ta-p/1880761

https://community.qlik.com/t5/Knowledge/Replicate-How-to-filter-records-by-using-before-image-data/ta-p/1837082

Re: Replicating only few rows via filter without dropping and truncating the table?

Heinvandenheuvel — Thu, 31 Mar 2022 14:33:37 GMT

>> if its possible to replicate(update) only specific rows in the table

Have you consider a 'benign' update to the rows needed to be re-applied?

Simple: UPDATE <table> SET <pick-any-column> = <pick-same-column> WHERE <your selection criteria>

The exact execution of this depends somewhat on the source and target platform. If I recall correctly does apply these benign updates to the targets, but does not executed the store-changes in __ct tables for them.

Best thing to do is a sample task with just 1 table for your source/target and software version, start, wait, enable full verbose target_apply (and optionally source_capture), apply a benign update or two, reduce logging and check both the target tables for the desired effect as well as the rep-task log. Trust but verify!

Hein

Re: Replicating only few rows via filter without dropping and truncating the table?

Steve_Nguyen — Fri, 01 Apr 2022 18:34:55 GMT

@Aegis did any of the reply help ?