Input: Clo1 Clo2 A 1 B 2 A 3 Expected output Clo1 Clo2 B 2 Compare using col1

Hi @kirti.iyer Fortunately, it is a common request and there is plenty of solutions on the forum. One of them here: [image] Remove duplicate rows based on a value from a single data column Help @banerjeerules check attached file i hope its useful RemoveDuplicatesInSingle…

Hi @kirti.iyer Try Remove Duplicate rows activity it may help you. regards, Pathrudu

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

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: [image] Compare 2 column values and delete identical rows through LINQ Help And the workflow as xaml file, just because I want…

@loginerror I need your help because I want to check duplicate for multi columns. How to add another column in this Value(InArgument)? dt25.AsEnumerable().GroupBy(Function(a) a.Field(Of String)(“Invoice No.”)).Select(Function(b) b.First).CopyToDataTable() Another column: Invoice Date Invoice Amo…

Remove rows or duplicates from datatable

Help

loginerror (Maciej Kuźmicz) August 27, 2018, 6:54am 2

Hi @kirti.iyer

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

Topic		Replies	Views
Remove duplicates in DT for specific columns and keep all column and values Studio datatable , excel , studio , question , activities_panel	5	3513	August 27, 2021
Remove duplicates from a specific column Help	15	9335	November 26, 2019
Remove all duplicates rows based on a column Studio datatable , studio , question , activities_panel , for-each-row	3	107	November 14, 2024
I want to remove duplicate rows from datatable by comparing single column Studio datatable , activities , question , data_manipulation	13	5417	March 3, 2020
Check for duplicate values present in particular column Studio datatable , studio , question , activities_panel	4	3287	March 8, 2021

Remove rows or duplicates from datatable

Related topics