Hi,
I want to create a Notication Action Flow for new found duplicates for our Accounts Payable use case. Right now I can only get all available duplicates not only the ones which came with the latest delta load
Thank you!
I think you can use columns _CELONIS_CHANGE_DATE and _CELONIS_CL_TIMESTAMP in the tables that come from extractions. (I think _CELONIS_CL_TIMESTAMP appears only on tables extracted with the Replication Cockpit )
HTH
Hi, I think you can take the timestamp or add days in a filter (example FILTER "KNAT". "EXDT" < ADD_DAYS ( TODAY ( ) , 8 ) ; )
Hey there,
I'd try to count duplicates and filter on the counter >=2.
You also have to add this counter to the signal id.
Result should be that signal is raised, whenever counter raises and afterwards filter reduces single occurances.
Hope that help a bit.💪 👍
jonas.venne wrote:
Thank you. It worked out perfectly with your help!
Glad to hear that. You are welcome :-)
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.