To Find duplicate and add total

[mmustkee]

x

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.

[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.

[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 · Accepted solution]

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: