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.