Hi all, The input file is below [16617570191227255305646243644673] after reading the input file, the datatable is as below: [16617532214116913767026907965262] The required output is as below [16617532859586246793494035317615] Condition is to filter rows with Yes values in the Actual colum…

Hi @Ray_Sha1 Try this LINQ ( From r in dt_Data.AsEnumerable() Where dt_Data.Rows.IndexOf(r).Equals(0) Or r("Actual").ToString.Trim.ToUpper.Equals("YES") ).CopyToDataTable

Hey @Ray_Sha1 Does this mean, you want to filter rows which has values in all the 4 columns ? Thanks #nK

Hi, Filter needs to be done based on the actual column, with values yes in it. Thanks!

Okay perfect. So Filter Data Table should do the job. Did you try that please ?

Hey @kumar.varun2 This works correctly. Thanks!

Linq to Filter datatable with two rows as header values

Help Studio

Gokul001 (Gokul Balaji) August 29, 2022, 7:45am 5

Duplicate : Linq to filter data - #18 by Gokul001

Topic		Replies	Views
Linq to filter data Studio datatable , excel , uiautomation , pdf , orchestrator , robot , activities , studio , data_scraping , studiox , question , activities_panel , linq , linq-query , linq-quey	18	1856	August 29, 2022
Extract values from excel- datatable Activities datatable , excel , activities , studio , activities_panel , linq , excel-scope , datatable-filter , excel-tables , linq-query , linq-quey , datetime-linq , select-datatable , excel-datatable , for-each-datatable	8	1149	August 27, 2022
How to filter rows in DT for same value in two columns? Activities excel , activities , question	7	1961	October 23, 2022
Check two columns in datatable Activities datatable , excel , activities , studio , question	10	1228	November 22, 2022
Exclude rows from Excel if value of column is Yes Studio studio , question , activities_panel	6	73	September 5, 2024

Linq to Filter datatable with two rows as header values

Related topics