Expand my Community achievements bar.

Submissions are now open for the 2026 Adobe Experience Maker Awards.
SOLVED

Can you create a lookup schema on a lookup schema in RTCDP?

Avatar

Community Advisor

Hi Adobe Community,

 

I need to bring in a new table in AEP that doesn't contain any of our primary identifiers (table A). So, the plan is to bring it in as a lookup table. However, the only field that I can link this new lookup table to in my system is a field that is already in a lookup table (table B). In the UI, I don't see a way to create a relationship on this field in table B which makes me think that you cannot create a lookup on a lookup. I feel like this should be possible since a lookup is essentially just a join on that field. If I make this field a primary identity in table B, would I be able to create a relationship with table A?

 

Thanks,

Nick

Topics

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

1 Accepted Solution

Avatar

Correct answer by
Level 8

Hi @NickMannion ,

Yes - but only if the field in table B is set up as an identity (profile-enabled). If it’s just a regular attribute, you can’t create a UI relationship from A to B.

Reference:

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

Thanks,

Ankit

View solution in original post

4 Replies

Avatar

Correct answer by
Level 8

Hi @NickMannion ,

Yes - but only if the field in table B is set up as an identity (profile-enabled). If it’s just a regular attribute, you can’t create a UI relationship from A to B.

Reference:

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

Thanks,

Ankit

Avatar

Level 10

Custom query in Query Service using SQL?

Avatar

Community Advisor

HI ,

 

  In our current setup, we use relationships for AJO lookup data and leverage them accordingly. For non–profile-enabled datasets, we use the datasetLookup function for email personalization and offers. I also noticed one more approach https://experienceleague.adobe.com/en/docs/journey-optimizer/using/data-management/lookup-aep-data

 

Thank you,

Uma

 

Avatar

Administrator

Hi @NickMannion,

Were you able to resolve this query with the help of the provided solutions, or do you still need further assistance? Please let us know. If any of the answers were helpful in moving you closer to a resolution, even partially, we encourage you to mark the one that helped the most as the 'Correct Reply.'

Thank you!



Sukrity Wadhwa