Creating multiple relationships on the same profile enabled field

[NickMannion]

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 solution]

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.

[NickMannion]

Thanks for the reply, Kumar. We ended up creating a second relationship with a different field.

Thanks,

Nick