Hi,Thanks for your answers! I found the solution thanks to Adobe Support’s AI, which suggested using ARRAY_AGG instead of ARRAY, along with adding a GROUP BY on the ID.Interestingly, ARRAY_AGG isn’t mentioned in Adobe’s documentation, but fortunately, it works!Here’s the query structure needed to pe...

Hi everyone, I’m facing a challenge I haven’t been able to solve yet. I have an Experience Event dataset that contains multiple rows per ID, and I need to transform it into a Profile dataset by aggregating all rows for a given ID into a single row, using arrays to store the values. Here’s an example...