Remove rows or duplicates from datatable


#1

Input:

Clo1 Clo2
A 1
B 2
A 3

Expected output

Clo1 Clo2
B 2

Compare using col1


#2

Hi @kirti.iyer

Fortunately, it is a common request and there is plenty of solutions on the forum. One of them here:


#3

Hi @kirti.iyer

Try Remove Duplicate rows activity it may help you.

regards,
Pathrudu


#4

My requirement is if duplicates are there then it should remove both.
Input
A
B
A

Output
B

I dont want duplicates


#5

Slightly less common request, but there you go :slight_smile:

DistinctRows_LINQ2.zip (8.0 KB)

It is a variation of the solution from this topic:

Let me know if you have any questions. It is more of an advanced way of handling it.