Groupby JSON Attribute

InsightConnect Workflows
1

Hi, I have a JSON array that contains objects:

ex: [{a: 1, b: 2}, {a: 1, b: 3}, {a: 2, b: 5}]

I’d like to perform a groupby (a) so I can print it out in the following format:

a: 1
b: 2
b: 3

a: 2
b: 5

What would be the best way to do this in ICON?

2

I’ve solved the issue by using the JQ plugin (Group by fields in CSV - #3 by elijah_martin-merrill)