Need help to Combine duplicate rows with one column being unique

[sophie_mackintosh]

I have tried lots of ways in Alteryx to allow me to combine the duplicate rows - where  everything is  the same expect the amount I would like to combine these so i  get one row with an amount like 6777000 + 123000 = 69000000

ideally what I want:

Key	ID	DPOT_ID	DEPOT_2	ID_2	CURRENCY	AMOUNT
B2RB0L0	20825CAP95	N053	1155	10097609	USD	69000000

what I have:

Key	ID	DPOT_ID	DEPOT_2	ID_2	CURRENCY	AMOUNT
B2RB0L0	20825CAP95	N053	1155	10097609	USD	6777000
BG48SD0	20825CAP95	N053	1155	10097609	USD	123000
BFMLP44	92857WBL37	N053	1155	18894891	USD	1228000
BYWFV88	92857WBL37	N053	1155	18894891	USD	6666000
BDZTYH7	1684780205	N001	1155	17145512	GBP	2087000
BZ0WZJ4	1684780205	N001	1155	17145512	GBP	181000
BF2GGF2	1862518062	N001	1155	19338555	GBP	361000
BF2GGF6	1862518062	N053	1155	19338555	GBP	22259000

I have tries lots of ways, can anyone suggest something 'easy' in Alteryx?

[DavidP]

Like this?

[BrandonB]

The summarize tool should help here

Key -> First

ID -> Group By

DPOT ID -> Group By

DEPOT_2 -> Group By

ID_2 -> Group By

Currency -> Group By

Amount -> Sum

[sophie_mackintosh]

I'm going to try this and let you know - as thier are many records which are not duplicates based on those fields, and i do not want them combined. like the last row for example. I'll try your example tough thank you !

[JosephSerpis · Accepted solution]

Hi @sophie_mackintosh I mocked up a workflow let me know what you think?

[sophie_mackintosh]

What will happen to the last two rows, if I use summarize?

[BrandonB]

The last two rows would exist as is

[sophie_mackintosh]

This worked! Thank you so much!