Exporting an array into aggregated text

How To
,
1

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!

2

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
3

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