Summarizing the values based on IDs

[RoxanneR]

Hi 

I am struggling with this scenario

What I want to do in is: Add all of the values in the "SUM Value" column for each unique combination of General ID and ID.

The output should look like the "SUM values" column, where all the values for each unique General ID and ID would be added together. 

The columns Column 1, Column 2, Column 3 shouldn’t be summarized but I will also need them to be included in the output.

Column 1	Column 2	Column 4	General ID	ID	Value	SUM Value
Description	Country	City	10	101	0
Description	Country	City	10	101	20	20
Description	Country	City	12	102	30
Description	Country	City	12	102	30	60

I tried Summarize + Join but unsuccessfully because after JOIN I had this result -which isn't correct

Column 1	Column 2	Column 4	General ID	ID	Value	SUM Value
Description	Country	City	10	101	0	20
Description	Country	City	10	101	20	20

Second question would be how can I summarize the values in SUM Value column without loosing the first 3 columns?

Thank you!

[Raj]

DO you want your output as

Column 1	Column 2	Column 4	General ID	ID	Value	SUM Value
Description	Country	City	10	101	0	20
Description	Country	City	10	101	20	20
Description	Country	City	12	102	30	30
Description	Country	City	12	102	30	60

or 

Column 1	Column 2	Column 4	General ID	ID	Value	SUM Value
Description	Country	City	10	101	0	20
Description	Country	City	10	101	20	20
Description	Country	City	12	102	30	60
Description	Country	City	12	102	30	60

[RoxanneR]

Hi, 

like this-

Column 1	Column 2	Column 4	General ID	ID	Value	SUM Value
Description	Country	City	10	101	0
Description	Country	City	10	101	20	20
Description	Country	City	12	102	30
Description	Country	City	12	102	30	60

or - 

Column 1	Column 2	Column 4	General ID	ID	Value	SUM Value
Description	Country	City	10	101	0	20
Description	Country	City	10	101	20
Description	Country	City	12	102	30	60
Description	Country	City	12	102	30

[CoG]

It seems you have two identical threads open, have you seen the solution I have provided here: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Adding-up-values-based-on-ID/t...