Skip to main content

Hey community,

 

Is it possible to combine two ocpm objects with each individual eventlog to combine into on object & eventog?

My szenario is that i have two objects for two different type of documents. They have the same structure and events but they are not named same as each event ends with they name of their type.

And i want to perform on both the same analysis and i am looking for a way instead of duplicating all analysis and adapting the kpi to simply my it. So both less duplicate work for me and easier for the enduser to work with. 

Is there like a “union” function to join them or is it possible with a parameter to switch the object/eventlog in a view?

 

Thanks in advance

 

Hi Johannes,

 

Yes, it’s possible to combine two OCPM objects, each with its individual event log, into a single object and event log in Celonis. 

 

You can use the `MERGE_EVENTLOG` function, which merges two activity tables (event logs) into a single, combined event log. Use the following syntax to merge the event logs:

MERGE_EVENTLOG(
"ActivityTable1"."ActivityColumn",
"ActivityTable2"."ActivityColumn"
)

 

Hope this helps!


Reply