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: KeyIDDPOT_IDDEPOT_2ID_2CURRENCYAMOUNTB2RB0L020825CAP95N053115510097609USD69000000 what I have: KeyIDDPOT_IDDEPOT_2ID_2CURRENCYAMOUNTB2RB0L020825CAP95N053115510097609USD6777000BG48SD020825CAP95N053115510097609USD123000BFMLP4492857WBL37N053115518894891USD1228000BYWFV8892857WBL37N053115518894891USD6666000BDZTYH71684780205N001115517145512GBP2087000BZ0WZJ41684780205N001115517145512GBP181000BF2GGF21862518062N001115519338555GBP361000BF2GGF61862518062N053115519338555GBP22259000 I have tries lots of ways, can anyone suggest something 'easy' in Alteryx?

Need help to Combine duplicate rows with one column being unique

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?

Datasets

Output

Tips and Tricks

Transformation

Accepted answers

JosephSerpis

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

Duplicates_19032020.yxmd

All comments

DavidP

Like this?

summarize group by.yxmd

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

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

Duplicates_19032020.yxmd

sophie_mackintosh

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

sophie_mackintosh

This worked! Thank you so much!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703