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

Linq to Filter datatable with two rows as header values

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

Linq to Filter datatable with two rows as header values