Aggregate function w/ grouping?

[syadnom]

on 1.107.4
trying to figure out how to get a group by in a no-code way with aggregate (or other) function.

I have a list of ids and ip addresses. the ids are duplicated, one for each ip address (some id’s have multiple IP addresses).

The aggregate node wont (or I can’t convince it) aggregate the IP addresses by id, so that there’s a single id row and an ip array with each of the IP addresses in it.

I basically want a group-by for id, and the ip in the aggregate.

Any ideas? again, no-code is the goal here.

[mohamed3nan]

Hi @syadnom,

If I understand you correctly, you can use the Summarize node with the Append “Aggregation” option:

• Field: ip
• Fields to Split By: id

Here is an example, hope the test data is correct:

[syadnom]

the aggregate node isn’t showing a group by option. v1.107.4. There are no group by, or operation type options at all.

[syadnom]

This solution with summarize works. thanks.