Cascade Filtering and counting

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?

Hi @necdetcilingir

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.


Worked perfectly! Thank you.

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.