Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Question about Summarization

thd-data-analyst
7 - Meteor

Hello Good morning,

 

I have a question regarding a problem that I am trying to solve. My dataset is something like this:

 

ItemCategoryAttributeValue
10000Cat1Att1Blue
10000Cat1Att1Green
10000Cat1Att1Yellow
10000Cat1Att1Black
10000Cat1Att1Blue
10000Cat1Att1Blue
10001Cat2Att2Pipe
10001Cat2Att2Comma
10001Cat2Att2Colon
10001Cat2Att2Pipe
10001Cat2Att2Comma
10001Cat2Att3Monkey
10001Cat2Att3Cat
10001Cat2Att3Dog
10001Cat2Att3Monkey
10001Cat2Att3Monkey

 

I want to find all the cases where the Values are repeating. For example I would like to get an output like this one:

 

ItemCategoryAttributeValueCount
10000Cat1Att1Blue3
10001Cat2Att2Comma2
10001Cat2Att3Monkey3

 

I am only interested in counting the repeating values. Can anyone suggest how I can go about this?

 

 

7 REPLIES 7
thd-data-analyst
7 - Meteor

I tried to do this but it did not help:

Summarize:

 

  • Item - Group By
  • Category - Group By
  • Attribute - Group By
  • Value - Count Distinct

 

 

JosephSerpis
17 - Castor
17 - Castor

Hi @thd-data-analyst I mocked up a workflow that should produce the output you describe. Let me know what you think?

AngelosPachis
16 - Nebula

Hi there, 

 try doing this

 

Annotation 2020-07-13 174344.png

bpatel
Alteryx
Alteryx

hi @thd-data-analyst ,

 

i used a combination of the summarize, sort and sample functions. hope this helps!

 

bpatel_0-1594658676778.png

 

thd-data-analyst
7 - Meteor

Thank you @JosephSerpis. I was missing the Value -  Group By.

thd-data-analyst
7 - Meteor

Thank you @AngelosPachis .

thd-data-analyst
7 - Meteor

Thank you @bpatel .

Labels