Summarize/Group By Not Working With More Than One Field

Question

Hi all,

I am having some issues with a simple group by function in the summarize tool. When I separate each bank in its own summarize tool I get the proper output, however when trying to just use one summarize tool I get the below incorrect output. You can see Bank 3 is not grouping properly by the unit price.  I need to group by service code, date and unit price by bank.  I would like to avoid using separate summarize tools and then trying to re-join the data. I have included a screenshot of how I am currently trying to group/sum in the summarize tool.

Current incorrect  output:

Service CodeDateBank 1 VolumeBank 1 Unit PriceBank 2 VolumeBank 2 Unit PriceBank 3 VolumeBank 3 Unit Price1200010/31/2020N/AN/AN/AN/A35.51200010/31/2020N/AN/AN/AN/A16101200010/31/2020N/AN/AN/AN/A34301200010/31/2020N/AN/A303301200010/31/2020N/AN/A5225301200010/31/2020N/AN/A3503301200010/31/2020446N/AN/A430

Desired output:

Service CodeDateBank 1 VolumeBank 1 Unit PriceBank 2 VolumeBank 2Unit PriceBank 3 VolumeBank 3 Unit Price1200010/31/20204463035.51200010/31/2020N/AN/A52216101200010/31/2020N/AN/A3504930

DawnDuong · Answer

Hi @lomeoari

in the current Summarize tool setting, There are nested “group by”, i.e. it asks Alteryx first to group by Unit 1 and then within each unique unit 1 further group by unit 2 and so on. That is why you are getting the so-called “incorrect” output (which is actually correct in the sense that the tool does exactly that it is asked to do”.

Without getting into whether multiple summarize tools and Joins are needed, what is the objective that you try to achieve? From the correct output sample, i am guessing that you try to list top 3 combinations of the price and volume for each bank unit which frankly does not quite make sense- so my guess must be wrong.

If you can share the sample/ mock data and explain the rationale / objective perhaps someone in the community can help better.

dawn

Qiu · Answer

@lomeoari 
Can you upload your original workflow?
I could not figure out the logic here.🤗