Compare data and if there exist same data for several row then mention the rule as parameter

[Digital_WorkerB]

I have data in collection, task is to check for multiple column with certain rules. For example: if Username column and employee ID matches then check for duplicates, if there exist a match then need to make note of the duplicate values and in output column write R1. Then next step is to check Username with employee wage then check for duplicates, if there exist a match then need to make note of the duplicate values and in output column write R2. Now need to append both the rules in one data item. How to i do all the rules check by using collection filter and update the output values to the same collection?

--------------------------------------------------
Disclaimer: This content was auto-posted from Stackoverflow. The original Stackoverflow question is here Stackoverflow Post, posted by Latha Shree.