CJA: Merge more than 10 schema fields

Question

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?

Elanchezhiyan_E · Answer

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.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded