Impossibility to split an item of a collection into an array

image
image
image
image
image

Hello,
I have my multiple time of rain showers in one item of a collection (screen 1) and i want to split into an array like the screen 3 in the aggregate to JSON module.

First i tried to use the split function (in the aggregate to JSON module) in order to split the times with the comma, it doesn’t work.
Then i’ve tried to split with “:” just to try and it gives me that (screen 4), i don’t understand why.

You shouldn’t do the split in the JSON module.

Can you put another array iterator after the first, then try what you did in your second screenshot in the new iterator?

2 Likes

Hello Sam,

Found the solution i can change my data structure in the aggregate to JSON module like on my screen.
Now i need to figure how to make it multiline because ticking multiline isn’t working.