Hello,
I have a table similar to the one on the left. I want to count the colors of each city and turn it into a table like the one on the right. The city list is not fixed, so I can’t use a fixed number of filters. I can’t be the first to encounter such a thing, but I couldn’t find it in the forum. Does anyone know an easy way to do this?
That’s a perfect job for the Unique concatenate with count function from the groupBy node. Use a Cell Splitter thereafter if you want individual columns.
3 Likes
Worked perfectly! Thank you.
1 Like
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.