Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
We are working on replication from IBM Informix to Snowflake, there is an archive job which runs everyday to delete the record older than 12 month based on the create date. We would like to skip the deletes happening for records that are 12 months older than created so that it would get deleted from target. is there any way to achieve this functionality in Qlik Replicate?
Hello @Sreekanth_333 ,
Qlik Replicate provides rich filter functionalities, you may use filter expression like:
$AR_H_OPERATION=="DELETE" AND $CRT_DATE<date('now','-365 day')
Hope this helps.
John.
Thank you for your great support @Sreekanth_333 . Feel free to let us know if you need any additional information.
Hello @Sreekanth_333 ,
Qlik Replicate provides rich filter functionalities, you may use filter expression like:
$AR_H_OPERATION=="DELETE" AND $CRT_DATE<date('now','-365 day')
Hope this helps.
John.
Thank you for your great support @Sreekanth_333 . Feel free to let us know if you need any additional information.