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

Creating new column and count

RandomPezzer
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

 

5 REPLIES 5
atcodedog05
22 - Nova
22 - Nova

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 😀👍

RandomPezzer
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. 

atcodedog05
22 - Nova
22 - Nova

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 😀👍

RandomPezzer
5 - Atom

@atcodedog05 Thank you for your help. 

atcodedog05
22 - Nova
22 - Nova

Happy to help 🙂 @RandomPezzer 

 

Cheers and Happy Analyzing 😀

 

Feel free to reach out if you face any issues 🙂

Labels