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

Question

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

AnkitJasani29 · Accepted Answer

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-uiThanks,Ankit

Umamaheswari_Yakkala · Answer

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

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded