I'd like to export all unique values of multiple attributes without having to use an aggregator > attributerenamer > attributecreator.
What I've got:
Table
ID,COLOR,TYPE
1,Blue,Slide
2,Red,Slide
3,Green,Merry-go-round
4,Green,Slide
What I want my export to look like:
COLUMN,VALUE,COUNT
TYPE,Slide,3
TYPE,Merry-go-round,1
COLOR,Blue,1
COLOR,Red,1
COLOR,Green,2
Now I know I can achieve this with alot of DuplicateRemovers or Aggregators, but I've got 100+ columns like this... Is there any other way?
Thanks in advance.
