Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Group By and count Problem

sanjit11
7 - Meteor

SAMPLE.jpg

 

 

 

 

 

 

 

 

I am trying to achieve the above result. The left one is the input and the output is on the right. Can someone help out

Thanks.

2 REPLIES 2
atcodedog05
22 - Nova
22 - Nova

Hi @sanjit11 

 

You can achieve this using crosstab tool.

 

Workflow:

atcodedog05_0-1625490038602.png

1. Creating a column count and setting values as 1.

2. Using crosstab tool with ID as key, Animal as Name and Count as values getting count table.

3. Using data cleaning tool to add 0's in place of nulls.

 

Hope this helps 🙂

 

sanjit11
7 - Meteor

Thanks alot atcodedog05 !

Labels
Top Solution Authors