I'm working on a project which asked to sum the two field and eliminate one line if they have the same attribute (in my case, ID number). For example, for my input below, as you can see, there are two entries with ID number 2, and the goal is to sum the two income with the ID 2 and get rid of one lines. It's straightforward in Excel, but I'm having difficulty implementing it into Alteryx, hope someone can help. Thanks!!
Input | Output | ||||
ID | Income | ID | Income | ||
1 | 5 | 1 | 5 | ||
2 | 7 | 2 | 17 | ||
2 | 10 | 3 | 15 | ||
3 | 5 | 4 | 16 | ||
3 | 10 | ||||
4 | 16 |
Solved! Go to Solution.