Good day fellow RPA Developers,
I have an INPUT data table dt_Transfer
From this data table, I want to perform the following:
- If the “Record Type” column of one of the duplicate row(s) has a value of “R” it should be retained. If that “R” column value has a duplicate too, the first row should be returned and update the “Remarks” column to “Reversed”.
- If the duplicate row(s) has a “O” value on “Record Type” column and it has duplicate row(s), then the first duplicate value should be returned and the “Remarks” should be updated to “Clawback.”
- If there are no duplicates, the “Remarks” should leave as blank.
How can I implement this in a LINQ?