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

[John_Man]

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

[DanIMS1 · Accepted solution]

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]

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