Filter out certain values in data

[Yugal_Raju]

Hello All,

In the below table I want filter out (remove) the values containing “900” using filter datatable.

Please help with the solution,

[ppr (Peter Preuss)]

Working with DataTables:

• Filter DataTable Activity: COndition - Not endsWith: “900”

OR

LINQ:
Assign Activity:
dtFiltered =

dtData.AsEnumerable.Where(Function (x) Not x("Number").toString.Trim.EndsWith("900")).CopyToDataTable

Handling empty results

[FirstAid] Handling of The source contains no DataRows exception

This FirstAid Tutorial will describe how a the source contains no DataRows EXCEPTION can be handled. Introduction Let’s have a look at the following filter data table scenario: Name CCode Tom US Charlotte FR Seema IN Jean FR Assignment: Filter all rows on a particular Country Code like FR, UK, ES, UK… Ensure that all CCode data column values are trimmed Ensure that the Filter check is case insensitive we can implement it e.g. with the help of a LINQ statement: dtData.AsE…

EDITED: fixed with NOT from keeping to removing

[lrtetala (Lakshman Reddy)]

Hi @Yugal_Raju

[Parvathy (PS Parvathy)]

Hi @Yugal_Raju

→ Read Range Workbook

Output-> dt
→ Use below syntax in Assign:

dt_Output = (From row In dt.AsEnumerable()
                     Where Not row.ItemArray.Any(Function(item) item.ToString().Contains("900"))
                     Select row).CopyToDataTable()

dt_Output is of DataType System.Data.DataTable
→ Write Range Workbook dt_Output

Hope it helps!!

[Parvathy (PS Parvathy)]

Hi @Yugal_Raju

→ Read Range Workbook

Output-> dt
→ Filter DataTable

→ Write Range Workbook dt_Output

Hope it helps!!