SOLVED
Merge Rows and Sum Field Valies
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
RicardoVales
5 - Atom
‎02-27-2020
03:15 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I have a table where I have dates on the rows, and countries on Columns.
Like this:
Country 1 | Country 2 | |
01/01/2018 | 1 | 4 |
02/01/2018 | 2 | 3 |
03/01/2018 | 3 | 2 |
04/01/2018 | 4 | 1 |
01/01/2018 | 7 | 8 |
03/01/2018 | 10 | 10 |
And I want to merge the rows that have the same value, and sum the value on the several columns.This would be the desired output.
Country 1 | Country 2 | |
01/01/2018 | 8 | 12 |
02/01/2018 | 2 | 3 |
03/01/2018 | 13 | 12 |
04/01/2018 | 4 | 1 |
What is the best way to achieve this?
Thanks for your help!
Solved! Go to Solution.
Labels:
- Labels:
- Help
2 REPLIES 2
16 - Nebula
‎02-27-2020
03:20 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @RicardoVales ,
I think, the Summarize tool would do the job. I've attached a sample workflow. Hope this is helpful.
Best,
Roland
‎02-27-2020
03:28 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you Roland.
I feel really stupid now.
Simple solutions and I was trying to complicate things.
