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

Summarize based on one column

Highlighted
7 - Meteor

Hi all,

 

I'm having a bit of a basic problem but cannot get the summarize tool to put out what I want right now unfortunately. My table looks like this:

 

Batch IDFile #Reg HoursO/T HoursHours 3 code (1)Hours 3 amount (1)Hours 3 code (2)Hours 3 amount (2)Hours 3 code (3)Hours 3 amount (3)Rate Code
212345663.07300101002
212345663.07315500002

22222

 

How can I summarize this and get a table like this? 

 

Batch IDFile #Reg HoursO/T HoursHours 3 code (1)Hours 3 amount (1)Hours 3 code (2)Hours 3 amount (2)Hours 3 code (3)Hours 3 amount (3)Rate Code
212345663.073155101002

 

Any help is greatly appreciated!

 

Thanks so much,

Akarsh

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Use a summarize tool as attached.

Workflow to summarize rowsWorkflow to summarize rows

Highlighted
7 - Meteor

Thanks so much - I didn't know about the "Max" summary!

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

There are a few different types of aggregations. Maybe the Hours Amount should be summed... I'll let you figure that out, but it's easy to change.

Labels