I have 3 tables in excel format Table 1 contains P2P activity data Table 2 contains inventory movement activity data Table 3 contains activity data for production order. Unfortunately they dont have common key , but each table dont have foreign key to link each other, can still event logs be merged using automerged functionality and represent on process explorer ?

Multievent log : Can 3 tables which dont have any foreign key be combined into multievent log functionality ?

I have 3 tables in excel format

Table 1 contains P2P activity data
Table 2 contains inventory movement activity data
Table 3 contains activity data for production order.

Unfortunately they dont have common key , but each table dont have foreign key to link each other, can still event logs be merged using automerged functionality and represent on process explorer ?

Page 1 / 1

I doubt it, although never tested this. Maybe if there is an indirect relationship via other table (and of course, havins a 1:N relationship between the activity tables)

I agree with @Guillermo Gost, since it should be possible to filter the table with each other.

If you can connect the case tables in a certain way, for instance the MARC table is involved in all the three processess, then you can make the Multi-eventlog functionnality. There is actually no need of a comon foreign key, but rather a direct or indirect relationships between case tables.

I hope it helps,

Dany

Reply

ANY QUESTION?

MORE CELONIS

CHECK US IN

Reply

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded

ANY QUESTION?

MORE CELONIS

CHECK US IN