Are referenced fields available in AJO journey

[ShivaniM]

Hello Team,

I would like to understand, is it possible to get the reference field from lookup dataset in AJO journey?

we have one individual profile schema with abandon cart data and one product catalog schema with custom class.

We have created a relationship between fields prod_id of both schema. 
will I be able to see fields from product catalog schema in AJO Journey.

[Mohan_Dugganab · Accepted solution]

You can leverage datasetLookup helper which is currently in Beta https://experienceleague.adobe.com/en/docs/journey-optimizer/using/content-management/personalizatio... for your case

[ShivaniM]

Thank you so much, it helped me.

I have one more question, prod_id field (from individual profile schema) is in an array and lookup field prod_code is normal field.

I have tried some ways, like xyz.object.0.prod_id and xyz.object.prod_id.0 but unable to get the value in email, it is reflecting as blank.

What is the correct way for this syntax.

{{datasetLookup datasetId="123456789121212" id=profile.xyz.AbandonCart.XYZ.PROD_ID result="store" required=false}}

{{store.xyz.ProductCatalog.coffeeName}}

here, prod_id is part of array field XYZ.
Do you have any idea around it.