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?
If the 2nd table in your problem description is wrong, how do you know which row to add the SUM Value to? Is it always the last row? or can it be any row as long as it is only one row (for given [General ID] and [ID])?
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 |
I would have done the same. You will need to summarize based on the General ID and then use the Join tool to get the missing fields back.