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

[John_Man]

Hi,

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

@brian_au 

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

[pradnya_balvir · Accepted solution]

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]

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