JSONARRAYSIZE

Syntax

JSONARRAYSIZE(<string containing a JSON array>)

Returns the number of elements of the selected JSON arrays.

Given the following data:

First create a group using GROUPBY(#RawData!Key).

Next create a list with GROUPCONCAT(#RawData!Name).

Use that list to create a JSON array with TOJSON(#sheet1!Name_List).

Then use JSONARRAYSIZE(#Sheet1!Name_JSON), and the results are the the number of elements in the corresponding JSON array.

Group	Name_List	Name_JSON	JSONARRAYSIZE returns
Group1	[Andy, Alba, Anna, Affa]	["Andy","Alba","Anna","Affa"]	4
Group2	[Jeff, June, Jack]	["Jeff","June","Jack"]	3
Group3	[Rick, Rode]	["Rick","Rode"]	2
Group4	[Molly]	["Molly"]	1