topic CT tables in Qlik Compose

CT tables

Tool_Tip — Mon, 14 Apr 2025 03:22:02 GMT

Dear Experts,

In our _CT tables we can see the changes made to the records and also some indicator values getting updated in the respective table as below picture such as INSERT, UPDATE or DELETE etc..

We need to know if it is possible to know which columns values are getting changed? or is there any method to know about it? Because if we have 30 columns in single record and if any changes happened in any of the column, for now we can see yes some changes made ( INSERT, UPDATE or DELETE) but it is difficult to know column is changed as we are manually checking each column which is time consuming as well as it can lead missing information as well.

Kindly advise.

Re: CT tables

sureshkumar — Fri, 18 Apr 2025 14:49:36 GMT

Hello @Tool_Tip

If you're using compose, In UI you can be able to see DML operations performed for which particular column.

Regards,
Suresh

Re: CT tables

Tool_Tip — Tue, 22 Apr 2025 04:40:27 GMT

Hi Suresh,

Can you please share the screenshot for the same

Re: CT tables

lind_oliveira20 — Wed, 21 May 2025 18:23:28 GMT

In Tasks Settings > Change Processing > Store Changes Settings, check the value set in the On Update field. If the Store before and after image option is not selected, change it to that. With this configuration, a Before operation will be recorded prior to other DML statements.

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