How remove unwanted specific rows

[suraj_gaikwad]

Hello,

In below image there is the column name (Match Type) in that column i have to remove the Confirmed where it’s available in the column remove whole row only I need to keep probable match

Thanks

[Parvathy (PS Parvathy)]

Hi @suraj_gaikwad

Assign activity:

dtData = dtData.AsEnumerable().Where(Function(row) row.Field(Of String)("Match Type") = "Confirmed").CopyToDataTable()

Hope it helps!!

[Shiva_Nikhil]

@suraj_gaikwad

datatable.AsEnumerable.where(function(x) x(“Match Type”).tostring.trim.equals(“Probable”)).copytodatatable

or you can use filter datatatable activity

cheers

[supriya117 (Supriya Allada)]

Hi @suraj_gaikwad

NewDataTable = YourDataTable.AsEnumerable().Where(Function(row) row("Match Type") <> "Confirmed").CopyToDataTable()

[Dilli_Reddy (Candy Reddy)]

Hii @suraj_gaikwad

(From row In inputDataTable.AsEnumerable()
Where Not (row(“ColumnName”).ToString = “Confirmed”)
Select row).CopyToDataTable

[lrtetala (Lakshman Reddy)]

Hi @suraj_gaikwad

You can try this use Invoke Code activity

Code:

' Assuming you have a DataTable named yourDataTable
Dim rowsToRemove As New List(Of DataRow)

For Each row As DataRow In DT.Rows
    If row("Match Type").ToString().Contains("Confirmed") Then
        rowsToRemove.Add(row)
    End If
Next

For Each row In rowsToRemove
    DT.Rows.Remove(row)
Next

Hope this helps!!

[lrtetala (Lakshman Reddy)]

@suraj_gaikwad

You can try above code it is working

How remove unwanted specific rows

Hi @suraj_gaikwad You can try this use Invoke Code activity [image] Code: ' Assuming you have a DataTable named yourDataTable Dim rowsToRemove As New List(Of DataRow) For Each row As DataRow In DT.Rows If row("Match Type").ToString().Contains("Confirmed") Then rowsToRemove.Add(row) End If Next For Each row In rowsToRemove DT.Rows.Remove(row) Next Hope this helps!!

I/P:

O/P:

Hope this helps!!

[supermanPunch (Arpan)]

Hi @suraj_gaikwad ,

Could you try with the Filter Datatable activity and check if it is able to get you the expected output ?

If not, we could move to the Linq Filter Expressions.

Also, Do note that we are manipulating the Datatable and hence the Modified Datatable needs to be written back to the Excel sheet(A New sheet if possible).

[Gokul001 (Gokul Balaji)]

HI @suraj_gaikwad

Simply you can Use FILTER DATATABLE activity

Regards
Gokul