To Find duplicate and add total

Hi Team,

I have sheet in which we have column "TN" in which we have duplicate values. I need to find out duplicate and then add a total of column "OA" and "OT" of that particular TN and then mention number of TN duplicate in column "Number of TN".

Example is as below for TN = 69

SN	TN	OA	OT	Total	Number of TN
10	69	3	63	354	3
27	69	82	24	354	3
28	69	178	4	354	3

Please help.

An Report.xlsx

Tips and Tricks

Accepted answers

kelvin_law1

Hi @mmustkee,

So you want to keep all 30 records in the output, correct?

If yes, I think you only need to delete the highlighted tools below and connect the Input tool directly to the L input anchor of Join.

Then you should be able to get an output with all your rows as the Input:

All comments

JeffK

Hi @mmustkee - Take a look at the attached workflow. I believe it accomplishes your goal and I left in the non-unique values just in case you need them downstream.

Duplicate with Totals.yxzp

mmustkee

Hi Jeff,

Thanks for your response however I want all data be it unique or duplicate since I need to add OA and OT in each case.

kelvin_law1

Hi @mmustkee,

So you want to keep all 30 records in the output, correct?

If yes, I think you only need to delete the highlighted tools below and connect the Input tool directly to the L input anchor of Join.

Then you should be able to get an output with all your rows as the Input:

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15865

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703