Am trying to filter out 0 for that column using the linq query below but it isn’t working and I’ve tried others but I have failed.
dTVariances.AsEnumerable.Where(Function(row) Not double.Parse(row("Variance (FCY)").ToString)=0).CopyToDataTable
dTVariances.AsEnumerable().Where(Function(row) Information.IsNumeric(row(8).ToString)).AsEnumerable().Where(function(row) Not double.Parse(row(8).ToString)=0).CopyToDataTable
Kindly advise on what I might be missing out on.
Thank you.
dtVariances.AsEnumerable.Where(Function (row) not row("Variance (FCY) ").toString = “0” or not row("Variance (FCY) ").toString = “0.00”).CopyToDatatable
I might be write the column name wrong, please be careful about this.
@Sudharsan_Ka@Gokul001
I’ve no idea why this query isn’t working because to me everything seems to be fine. Input.xlsx (9.3 KB)
I’ve shared the input file