(CJA) Derived Field Split function can only convert up to 10 items to an array? | Community
Skip to main content
John_Man
Community Advisor
John_ManCommunity Advisor
Community Advisor
August 4, 2025
Solved

(CJA) Derived Field Split function can only convert up to 10 items to an array?

  • August 4, 2025
  • 1 reply
  • 493 views

Hi,

 

We are dealing with a text delimited field and need to convert it to an array for reporting.

 

A Derived Filed is created and using the Split function for this, however, found that it seems only the first 10 items in the string are converted. For exmaple,

 

The original string field value is "A1,A2,A3,A4,A5,A6,A7,A8,A9,A10,A11,A12". The output array from the Split function only shows A1 to A10 i.e. without A11, A11.

 

Is there something missing or it's a known issue/limitation?

 

Thanks,

John

 

    Best answer by DanIMS1

    Hi @john_man,

    This looks to be a limitation of the split function. 
    I have just ran a simple test and the results seem to be limited to the first 10 values.

    Thanks,

    Dan

    1 reply

    DanIMS1
    DanIMS1Accepted solution
    Level 3
    August 4, 2025

    Hi @john_man,

    This looks to be a limitation of the split function. 
    I have just ran a simple test and the results seem to be limited to the first 10 values.

    Thanks,

    Dan

      John_Man
      Community Advisor
      John_ManCommunity AdvisorAuthor
      Community Advisor
      August 4, 2025

      Hi @danims1 

       

      Thanks for your help testing this.

       

      Tried to do this using the split function on the Data Prep level, and it works fine with all items returned in an array field. Maybe I will take this to Adobe Support to see if it's actually a bug that they can fix.

       

      Thanks,

      John

       

        Terms & ConditionsAccessibility statement

        Loading footer...