Remove Duplicate RowItem without changing rowindex Values

Help Activities
,
1
Order Code Description Transaction ID
99845 ghhg7 7655990123
99845 ggd6md 7765398767
67902 vfdd76 98570908
56789 b757g 2265689683
56789 nv59b 75648676
78905 m,5743 896464767
89056 xddg34 86588663

Hi,

Can anyone please suggest how to compare the duplicate rows in Datatable(inputDT)and Remove Duplicate Row item looping through each row and comparing each row using Filter Datatable activity.
i need out put like this:

Order Code Description Transaction ID
99845 ghhg7 7655990123
ggd6md 7765398767
67902 vfdd76 98570908
56789 b757g 2265689683
nv59b 75648676
78905 m,5743 896464767
89056 xddg34 86588663

Wothout Changing any row index

2

Hi @Krishna_Arjun

Try this:

uniqueDT = (From row In dt.AsEnumerable()
            Group row By key = New With {
                .OrderCode = row.Field(Of String)("Order Code"),
                .Description = row.Field(Of String)("Description"),
                .TransactionID = row.Field(Of String)("Transaction ID")
            } Into Group
            Select Group.First()).CopyToDataTable()

uniqueDT is of DataType System.Data.DataTable

Hope it helps!!

3

@Krishna_Arjun

check the reference

4

@Krishna_Arjun

Assign activity:
distinctRows = inputDT.AsEnumerable().Distinct(DataRowComparer.Default).CopyToDataTable()

Output DataTable:
distinctRows
5

2024-03-04 (1)
2024-03-04 (1)1920×985 83.1 KB

6

No It’s not working same data will come output

7

Hi @Krishna_Arjun

Please try this

image
image900×596 32.2 KB

image
image888×256 9.38 KB

Dim previousOrderCode As Object = Nothing

For Each row As DataRow In dataTable.Rows
    If previousOrderCode IsNot Nothing AndAlso row("Order Code").Equals(previousOrderCode) Then
        row("Order Code") = DBNull.Value
    Else
        previousOrderCode = row("Order Code")
    End If
Next

Input:

image

Output:

image

Regards,

8

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