Creating an array by id

Hello,

I have a MSSQL query which returns with plenty of date, I want to create an array for each rows that has same ID.

I tried couple of options but could not do it somehow.
Is there anyone who can help me with that?

[
{
"LOGICALREF": 390,
"CLIENTREF": 29,
"SOURCEFREF": 160,
"DATE_": "2022-01-22T00:00:00.000Z",
"TRANNO": "some numbers",
"TRCODE": 38,
"LINEEXP": "40056711 -",
"MODULENR": 4,
"FTIME": 170068012,
"AMOUNT": 89752.62,
"CYPHCODE": "",
"DEBIT": 89752.62,
"CREDIT": 0,
"TRCURR": 0,
"TRNET": 89752.62,
"DOCODE": "",
"CANCELLED": 0
},
{
"LOGICALREF": 391,
"CLIENTREF": 674,
"SOURCEFREF": 161,
"DATE_": "2022-01-23T00:00:00.000Z",
"TRANNO": "somenumbers",
"TRCODE": 38,
"LINEEXP": "13029322-C.80Y.92",
"MODULENR": 4,
"FTIME": 170072375,
"AMOUNT": 86163.27,
"CYPHCODE": "",
"DEBIT": 86163.27,
"CREDIT": 0,
"TRCURR": 0,
"TRNET": 86163.27,
"DOCODE": "",
"CANCELLED": 0
},

I want to use CLIENTREF as identifier and crate an array that has results with same identifier.

Hi @No_Name, so you’d like to have one item for each unique CLIENTREF value with an array of all matching results? If so, I think something like below would do the job:

Result: