Exporting an array into aggregated text

What are you trying to achieve?

I’m trying to obtain a text aggregating dates and names.
I’ve go to the point where I have an array aggregator outputting correctly my data :
OUTPUT
[
{
IMTKEY”: “Bacchus”,
“array”: [
{
“Date”: “2025-06-02”,
“Educ”: “Vanessa”
},
{
“Date”: “2025-05-30”,
“Educ”: “Charly”
},
{
“Date”: “2025-06-25”,
“Educ”: null
}
]
}
]

Now I’m trying to get an aggregated Text as follow:

  • 02/06/2025 — Vanessa
  • 05/06/2025 — Vanessa
  • 25/06/2025 — (vide si Educ absent)

This is to then export into a google document (billing) where I want them displayed as a table.

Steps taken so far

My PROBLEM is that when trying to aggregate these into a text aggregator I’m setting up as

  • {{formatDate(Date; “DD/MM/YYYY”)}} — {{Educ}}
    The variables Date and Educ are not recognised (displayed as Black)

When I try to set them as

  • {{formatDate(24.Date; “DD/MM/YYYY”)}} — {{24.Educ}}
    they appear in green, but light green

When I try setting as
{{formatDate(24.array[1].Date; “DD/MM/YYYY”)}} — {{24.array[1].Educ}}
to test if the system can access the array correctly, it work but (as expected) I only get the first row.
02/06/2025 — Vanessa

Can someone help me?
This seemed like pretty simple steps but can’t seem to make it work.

Thanks in advance!

Hey there,

do you need the array aggregator for something? Replace it with a text aggregator instead to get the text block you are looking for. Or use an iterator after the array aggregator.

1 Like

Indeed, getting rid of the array aggregator fixed it. thanks