as part of my workflow, I merged 4 different datatables into one single datatable. There could be duplicate rows in the merged datatable. Sample screenshot is below.
The order number will be populated in one and not the other between the duplicated rows. The client dispute id, invoice number and disputed amount are the common values between each set of duplicated rows.
my requirement is if client dispute id, invoice number and dispute amount are the same between any two rows, the one that doesn’t have the order number must be deleted.
I am not sure how to go about this scenario. can anyone suggest ways to go about doing this.
thank you for your assistance. I had to add the assembly reference to fix the issue. The initial piece of code you provided worked like a charm.
This community is awesome…Lots of experts actively engaging on the forum and helping people resolve their issues. Also the trove of knowledge that is shared through the forms is awesome. Extremely helpful.