CJA: Merge more than 10 schema fields

[MaríaPé]

In our CJA solution we have the need to merge about 50 different schema fields.

Creating a derived field with a merge is not an option, since the limit is 10 fields, and if a merge of a merge is made, the number of original fields is taken into account.

Is there any solution for this type of use case?

[kautuk_sahni]

@DavidRoss91 @_Manoj_Kumar_ @akshaykapil23 @BitunSenAEP @Kumar_Saurabh_ @AtulChavan @abhinavbalooni @saswataghosh Can you take a quick look at this question? Any guidance you can provide would be much appreciated!

[Elanchezhiyan_E]

If you're hitting the 10-field merge limit in CJA, you have two main options:

Pre-process and merge fields before ingestion into AEP

• Flatten and combine the 50 fields upstream (e.g., in your ETL or data lake)
• Store the result in a single field in your XDM schema
• Use that field directly in CJA

Simulate merges within CJA using analysis tools

• Use calculated metrics with conditional logic or
• Build filters with OR/AND conditions across multiple fields
• These don't create a literal merged field but can replicate the behavior

Good Luck..!

Thanks.