How to group by a property of a record

[io]

Hallo how do I group by a spread of records by one of their property?

GrouByProperty.vl (12.5 KB)

[sebescudie]

Hey,

GroupBy is indeed what you’re looking for, though its output is a bit cryptic. This was already mentioned in the following response :

Split a spread by list of indices

not sure I understand your problem but does this help? [image] the GroupBy region allows you to tell how you want your stuff to be grouped. in this case we say we want to group based on the first three characters of the string. one might want to make something more sophisticated to make sure you’re dealing with numbers (yesyesregex) but this is just to demo the principle :) then about the double foreach in the end… I don’t know really understand why we have to do it like that, but the splice…

In your case, that gives the following

GrouByProperty_2.vl (15.4 KB)

[antokhio]

Don’t forget you need to cache GroupBy otherwise it will reevaluate each iteration