CJA: Merge more than 10 schema fields | Community
Skip to main content
M
MaríaPé
February 24, 2025
Question

CJA: Merge more than 10 schema fields

  • February 24, 2025
  • 2 replies
  • 385 views

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?

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    2 replies

    kautuk_sahni
    Community Manager
    kautuk_sahniCommunity Manager
    Community Manager
    February 26, 2025

    @davidross91 @_manoj_kumar_ @akshaykapil23 @bitunsenaep @kumar29917170hcyp @atulchavan @abhinavbalooni @saswataghosh Can you take a quick look at this question? Any guidance you can provide would be much appreciated!

    Kautuk Sahni
    Elanchezhiyan_E
    Elanchezhiyan_E
    Level 2
    April 5, 2025

    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.

    Terms & ConditionsAccessibility statement

    Loading footer...