Need To Remove Rows Based On Condition

[Putta_Sri_Sai_Rishik_Chow (Putta Sri Sai Rishik Chowdary)]

Hi,

If data contains X then we need to remove that particular row. Attached snapshot.

Thanks,
Rishi

[Anil_G (Anil Gorthi)]

@Putta_Sri_Sai_Rishik_Chow

Read the data into datatble…then use the below in assign activity

Dt = dt.AsEnumerable.Where(function(x) Not x("Number").ToString.ToLower.Contains("x")).CopyToDataTable

Then write the dt back to excel

Cheers

[Manish540 (Manish Shettigar)]

Hi @Putta_Sri_Sai_Rishik_Chow ,

Check this below linq,

dt_filtered = (From x In dt_Input
Where Not(x("Number").ToString.Trim.ToLower.Contains("x"))
Select x).CopyToDatatable()

Hope this might help you

[Gvivek9889 (Vivek Gupta)]

Hi @Putta_Sri_Sai_Rishik_Chow

Also you can use filter datatable activity

try this also

Thanks

[Chirag_Shetty_Divakar (Chirag Shetty)]

@Putta_Sri_Sai_Rishik_Chow

Hope this helps,
Cheers.