Expand my Community achievements bar.

Adobe Experience Platform (AEP) & Apps User Groups are live to Network, learn, and share in your regional locations.
SOLVED

Creating multiple relationships on the same profile enabled field

Avatar

Community Advisor

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?

NickMannion_0-1751461993733.png

 

 

Thanks,

Nick

 

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Level 5

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.

 

View solution in original post

2 Replies

Avatar

Correct answer by
Level 5

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.

 

Avatar

Community Advisor

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

 

Thanks,

Nick