Skip to main content
  • EN
Hello all,

 

 

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.

 

 

Hi,

 

 

have you looked at the DuplicateRemover? You can select multiple attributes to get all the unique combinations of those attributes.

 

 

David
Hey David,

 

 

Yes, I've already used that, I actually want the unique values per attribute. So I end up using 100+ DuplicateRemovers or Aggregators (so I can COUNT as well). But I was wondering if there's a better way.
Thanks alot David, got exactly what I needed!

Reply


Community Stats

30,108
Posts
114,280
Replies
37,742
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.