CT tables

[Tool_Tip]

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. 

[sureshkumar]

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

[Tool_Tip]

Hi Suresh,

Can you please share the screenshot for the same

[lind_oliveira20]

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/Custom...