Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
ALTER.NEXT:

Join us on Dec 2 for a half-day virtual analytics + data science event!
US & CA customers only

SAVE YOUR SPOT
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
SOLVED

Creating new column and count

Highlighted
5 - Atom

Morning, 

 

Sorry if this has been covered already. 

 

I have a list of data by name, type of transaction, transaction code. 

 

I need to group it altogether but in a column format instead of row. 

 

for example this is how I've managed to get Alteryx to group it and to filter out 'Cancelled' in type of transaction. 

 

NameType of TransactionTransaction codeCount
RobNewCMV2
RobExistingPMC1
RobNewTSL4
JohnExistingTSL2
JohnExistingPMC4
JohnNewCMV3
BetsyNewPMC8
BetsyNewTSL6
BetsyNewCMV4

 

But I want it to show only the name once and the Count in a column format for each new or existing transaction code

 

For example: 

 

NamePMC NewCMV NewTSL NewPMC ExistingCMV ExistingTSL Existing
Rob024100
John030402
Betsy846000

 

Any help would be greatly appreciated. 

 

I have attached sample data to try an help understand my data easier. 

 

Many Thanks

 

Highlighted
17 - Castor

Hi @RandomPezzer 

 

Here is a workflow for the task.

Output:

atcodedog05_0-1605953733568.png

Workflow:

atcodedog05_1-1605953746728.png

Hope this helps 🙂


If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

Highlighted
5 - Atom

That's amazing thank you. 

 

If the Data didn't have a count column for example in excel to create a count i would use countifs (=COUNTIFS(A:A,"Rob",B:B,"New",C:C,"PMC") 

 

Is there anyone in Alteryx to create that count? then produce the same outcome you've just shown me. 

Highlighted
17 - Castor

Hi @RandomPezzer 

 

You can use summarize tool to grouby and count.

 

Updated the workflow with the file as data source.

atcodedog05_0-1605955284761.png

Hope this helps 🙂


If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

Highlighted
5 - Atom

@atcodedog05 Thank you for your help. 

Highlighted
17 - Castor

Happy to help 🙂 @RandomPezzer 

 

Cheers and Happy Analyzing 😀

 

Feel free to reach out if you face any issues 🙂

Labels