Skip to main content

Hi everyone,

 

I am trying to modify the duplicate checker app.

Precisely, I have a column in BSEG (called MANUAL_CN, of Yes/No type) which I would like to use as a filter which exclude groups of potential duplicate invoices if there is at least one invoice for which BSEG.MANUAL_CN='Yes'.

Unfortunately, I am in the situation where no common table could be found so I was wondering if there is a workaround of this issue.

 

Here is the data model:

image.pngI have tried to use BIND function, but not successfully... so any suggestions would be highly appreciated!

 

Thanks in advance!

@victor.p , you need to add a filter in the knowledge model. Your filter has to leverage PU_COUNT function. E.g.: 2 options to filter...

  1. Validate the total invoices in the group is equal to the invoices where BSEG.MANUAL_CN='No'. or
  2. Validate the PU_COUNT of invoices with BSEG.MANUAL_CN='Yes' = 0 (zero)

https://docs.celonis.com/en/pu_count.html


@victor.p , you need to add a filter in the knowledge model. Your filter has to leverage PU_COUNT function. E.g.: 2 options to filter...

  1. Validate the total invoices in the group is equal to the invoices where BSEG.MANUAL_CN='No'. or
  2. Validate the PU_COUNT of invoices with BSEG.MANUAL_CN='Yes' = 0 (zero)

https://docs.celonis.com/en/pu_count.html

Hi Esteban,

Thank you for your reply!

I have also tried FILTER PU_COUNT()>0 but the problem is that I need to use other nested PU-functions and given that there is not a common table, I can't build the PU_COUNT - that's what the issue is.


Reply