Unify Event Data Across Schemas and View Merged Data in the UI

[ZacharyTa1]

Hi Experience League Community,

I have a case where fragments of event data are stored in two databases, and I am seeking a way to unify this data into a single event. I tested creating a relationship field and was able to reference the schema fields in segmentation.

I would like to know:

1. Is this the only implication of implementing a schema relationship?
2. Is there a way to visibly see the merged event data in the UI? For example, can we view a single event containing all fields from both the source schema and the reference schema?

Here are my schemas:

Schema #1 (Event Class):

• _id
• timestamp
• eventType
• reservationId
• transactionId (relationship field)
• amount

Schema #2 (Custom Class):

• transactionId (primary ID)
• memberId
• orderType
• outletId

I would appreciate it if anyone could share their thoughts on this.

Regards,
Zac

[kautuk_sahni]

@brekrut@Jennifer_Dungan@this-is-bob@MeitMedia@SachinJa4@arundeepjain

Kindly take a moment to review this question and share your valuable insights. Your expertise would be greatly appreciated!

[RiteshYadav18 · Accepted solution]

@ZacharyTa1 can you check below gives 

https://experienceleague.adobe.com/en/docs/experience-platform/profile/union-schemas/union-schema 
Check for XDM Event Class in ur case