How to calculate time of changes within Qlik Replicate

[KellyHobson]

AR_H_TIMESTAMP is the time associated with the change record and indicates when the change happened on the source. The AR_H_COMMIT_TIMESTAMP indicates when the change was committed on the source.

For reference, see Discussion: Difference Between AR_H_TIMESTAMP and AR_H_COMMIT_TIMESTAMP

If you would like to capture an instance when Qlik Replicate is making changes to target you can add a column via global transformation or at the table level:

1. Column Datatype = DATETIME(6)
2. Computation expression = datetime('now','localtime')

The expression, datetime('now','localtime') will capture the timestamp of records being inserted, deleted or updated in Replicate. We currently do not capture the time on the target system.

Environment

• Qlik Replicate 

The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.