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.
Solved! Go to Solution.
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.
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.
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: