(CJA) Derived Field Lookup function with array field as input | Community
Skip to main content
John_Man
Community Advisor
John_ManCommunity Advisor
Community Advisor
August 5, 2025
Solved

(CJA) Derived Field Lookup function with array field as input

  • August 5, 2025
  • 1 reply
  • 494 views

Hi,

 

We are working on CJA  to perform a custom lookup with an array of IDs, with reference to below link,

 

@brianau1 

 

A Guide to Understanding Adobe Customer Journey An... - Adobe Experience League Community - 648749

 

The mapping is done in the CJA Connection level and it work fine i.e. we can have a output array field of the corresponding lookup names.

 

However, since there is another ID field that need to leverage the same lookup data set, we have to create a Derived Field and use the Lookup function, but we found that the schema array field is not avalable in the input value field. 

 

We tried to output an array from the Split function and use it as input for the Lookup function and it works fine.

 

So the question is whether the Derived Field Lookup function can support schema array field as input?

 

Thanks,

John

 

Best answer by pradnya_balvir

Hi @john_man ,

 

No, as of now, the Derived Field lookup() function in CJA does not directly support schema-level array fields as input.

However, it does support array inputs, if the array is constructed dynamically (e.g., using split() or map()).

You can submit feedback to Adobe to enhance support for schema-level arrays in Derived Fields, as this is a limitation that has come up in many CJA implementations.

 

Thanks.

Pradnya 

1 reply

pradnya_balvir
Community Advisor
pradnya_balvirCommunity AdvisorAccepted solution
Community Advisor
August 5, 2025

Hi @john_man ,

 

No, as of now, the Derived Field lookup() function in CJA does not directly support schema-level array fields as input.

However, it does support array inputs, if the array is constructed dynamically (e.g., using split() or map()).

You can submit feedback to Adobe to enhance support for schema-level arrays in Derived Fields, as this is a limitation that has come up in many CJA implementations.

 

Thanks.

Pradnya 

    John_Man
    Community Advisor
    John_ManCommunity AdvisorAuthor
    Community Advisor
    August 5, 2025

    Hi @pradnya_balvir 

     

    Thanks for your reply. We used to use the Split() function to work with Lookup() for array of items. However, we recently found that it seems the Split() function can only return the top 10 items in the delimited text field, and thus have to revisit this.

     

    I have created an Idea for this feature request.

     

    Thanks,

    John

     

    Terms & ConditionsAccessibility statement

    Loading footer...