Schema relationship & dataset lookup in AJO | Community
Skip to main content
Michael_Soprano
Michael_Soprano
Level 10
April 9, 2026
Question

Schema relationship & dataset lookup in AJO

  • April 9, 2026
  • 2 replies
  • 16 views

I have relationship between these two schemas: 

  1. profile schema with ID of user’s favourite petrol station 
  2. non profile schema with relationship to schema from point A. All the details about petrol station - what is available etc 

Does it make sense to use the schema from point B as a lookup schema in AJO? 

2 replies

Asheesh_Pandey
Community Advisor
Asheesh_PandeyCommunity Advisor
Community Advisor
April 12, 2026

Yes ​@Michael_Soprano This is a valid pattern, but there is an important exception.
It works well for enrichment to segmentation, but AJO (Journey Optimizer) has limitations on how lookup data can be used at runtime.

In AJO personalization / message templates, you typically cannot directly access lookup attributes. If you need to use them in AJO, I recommend bringing the required station attributes into the profile

- Asheesh
DavidKangni
Community Advisor
DavidKangniCommunity Advisor
Community Advisor
April 13, 2026

​@Michael_Soprano 

  • for segmentation you can use the schema relationship
  • for personalization and condition in journeys, you can use dataset lokup in AJO with the new dataset lookup activity

Thanks,

David 

David Kangni
Terms & ConditionsAccessibility statement

Loading footer...