Alteryx community,
I have a record set where Column A contains unique identifiers, Column B contains a string, and Column C contains a numerical value. However, in the record set, there may be duplicates in Column A. What I'd like to do is merge the duplicate rows so that the unique identifier is retained, as well as the string in Column B where the numerical value was higher in Column C.
(Note: Rows 1 and 2 were originally part of separate tables, and were unioned.)
An example:
| Column A | Column B | Column C |
| 123456789 | Dog | 100 |
| 123456789 | Cat | 10 |
In this case, I want to retain "Dog" from Row 1 because the numerical value is 100 but add the 10 from Row 2. The end result should transform to this:
| Column A | Column B | Column C |
| 123456789 | Dog | 110 |
I can do this in SQL using SUM and CASE WHEN clauses and I'd imagine I'm using the Summarize and/or Filter nodes, but I can't quite figure it out.
