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

Summing Column Values based on criteria

ljohn
7 - Meteor

Hello,

 

The way my data is structured, its proving challenging to transpose and add.

 

This is what my data looks like -- Based on multiple criteria: Name and 'P' number, I need to get the sum of Counts.

 

ljohn_0-1596218256049.png

 

So the output would look like

ljohn_1-1596218378205.png

 

Anyway I can manipulate this data and get the required output?

 

 

4 REPLIES 4
JosephSerpis
17 - Castor
17 - Castor

Hi @ljohn  I mocked up a workflow that nearly matches your output. The only values that doesn't match is Mango P1. Let me know what you think?

ljohn
7 - Meteor

Thank you for the quick response!

I am trying it out with my dataset. Its a pretty huge dataset & giving me some errors.

More to follow...

ljohn
7 - Meteor

Thank you very much! I think I am almost there but your solution definitely answers the question I had. 

ljohn
7 - Meteor

I am unable to view the data in a presentable format given the amount of information and the 'Null cells'

 

Tried transposing the data in order to show only values that have data -- 

 

For Example:

 
 Top Store 1CountTop Store 3CountTop Store 3Count
MangoP111P212P35
 

notice that Mango doesnt show P4 becuase it is Zero

 

I used a Summarize tool after the Join which gives me:

MangoP111
MangoP212
MangoP35
AppleP13
AppleP212
AppleP35
AppleP48

 

Now this just needs to be transposed to look like the example above...

 

 

 

 

 

Labels