Question

Distinct values to export?

  • 4 February 2014
  • 3 replies
  • 4 views
R
Badge
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.

 

 

3 replies

david_r
Rank
Userlevel 4
Hi,

 

 

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

 

 

David
R
Badge
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.
R
Badge
Thanks alot David, got exactly what I needed!

Reply


Community Stats

28,659
Posts
109,313
Replies
36,529
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.