Deleting matching pairs from datatable(the values swapped between columns)

Col A Col B
AV123 GG987
FG145 BB488
GG987 AV123
KL489 LL778

Here Row1 and Row 3 are basically pairs with swapped values between them. I need to delete only one of them (either 1 or 3). So the Resultant table will be

Col A Col B
FG145 BB488
GG987 AV123
KL489 LL778

OR

Col A Col B
AV123 GG987
FG145 BB488
KL489 LL778

How to do this ? Can anyone please suggest anything on this subject?

@LITTLE_DINO Please check below workflow.

Duplicates.xaml (14.0 KB)

1 Like

Here is the c# code (replicate in UIPath) and output for your requirement.
It deletes duplicates as well as swapped duplicates. Have a look -

Regards,
Karthik Byggari

Thank You so much … Your solution is perfect !!!

1 Like

@LITTLE_DINO Your welcome :slight_smile:

Thank You :slight_smile:

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.