Skip to main content

Celonis Product Documentation

Workaround for a filter via JOIN condition

Replications don't support joins on other tables, so if you need to apply a filter based on a join condition, that would be impossible.

The recommended workaround is to create a data job that runs at a certain frequency (i.e. weekly) to clean up unused records in Celonis. Suppose you have a table T1 which should be filtered based on T2.COL1 = 'A'. Your "cleanup job" would include the following statement

DELETE * FROM T1 AS P INNER JOIN T2 AS Q ON P.PK = Q.PK WHERE Q.COL1 != 'A';