Creating multiple relationships on the same profile enabled field

Question

Hi Adobe Community,
 
So, my team has 2 lookup tables that we have created. We want to establish a relationship on the same profile enabled field and both of these datasets. So we were able to create a relationship with the first table but when we tried to create a relationship with the second table, we don't see a way to do it in the UI (see below). Is it possible to create a relationship between the same profile enabled field and 2 different datasets? Anyone have any ideas?

Thanks,
Nick

KumarRishii · Accepted Answer

Hi @nickmannion
You cannot create two relationships using the same profile-enabled field to different datasets in AEP via the UI. AEP allows only one relationship per field. To work around this, you can either:

1) Use a different field for the second relationship.
2) Combine both lookup tables into one and create a single relationship.
3) Use derived/computed fields or identity stitching to model the relationships differently.

https://experienceleague.adobe.com/en/docs/experience-platform/xdm/tutorials/relationship-b2b

I hope the above work around helps clarify your queries.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded