hi i want to filter a data table and if the condition of filtering not met. it will proceed to the next sequence. how can i do it. ty in advance O_Filtered_BSP094 = (From r In BSP094_ADJUSTED_DT.Select() Where r(46).Equals(“O”) Select r).CopyToDataTable

[image] ldiaz: (From r In BSP094_ADJUSTED_DT.Select() Where r(46).Equals(“O”) Select r).CopyToDataTable @ldiaz Please try like this BSP094_ADJUSTED_DT.AsEnumerable.Where(function(x) x(46).ToString.Trim.Equals("O")).CopyToDataTable Hope you are trying to filter 47th column with O cheers

Filtering data table and making condition in it

Help Something Else

system (system) Closed December 26, 2022, 8:21pm 4

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

Topic		Replies	Views
Filter Data Table from excel Studio studio , question , template	10	484	September 16, 2023
Filter using LinQ Studio studio , question , activities_panel	3	688	February 3, 2023
Filter the Datatable using Linq Studio studio , question , project_panel	4	682	October 19, 2023
How to filter value using query instead of filter data table Studio excel , studio , question	7	1243	February 7, 2023
URGENT: Filter datatable Help studio	18	6481	January 19, 2022

Filtering data table and making condition in it

Related topics