Hello Good People, 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. [image] dTVariances.AsEnumerable.Where(Function(row) Not double.Parse(row("Variance (FCY)").ToString)=0).CopyToDataTable dTVariances.AsEnumerable(…

If you dont want that zero with the decimal to your datatable try with this @Kakooza-Allan-Klaus dT.AsEnumerable().Where(Function(row) Information.IsNumeric(row(0).ToString)).AsEnumerable().Where(function(row) Cint(row(0).ToString)<>0).CopyToDataTable Regards Sudharsan

How to filter out the zero value from that column?

Help Studio

Sudharsan_Ka (Sudharsan Ka) October 4, 2022, 9:19am 6

HI @Kakooza-Allan-Klaus

Your datatable should consists of rows =0 right not 0.00

Regards
Sudharsan

Topic		Replies	Views
How to filter value using query instead of filter data table Studio excel , studio , question	7	1243	February 7, 2023
Filter Data Table To Get Only Even Numbers Help datatable	12	2781	February 2, 2022
Error the source contains no datarow Studio	6	1685	December 8, 2021
Filter dt by double precision numbers Studio datatable , excel , studio	15	1834	September 13, 2021
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	1726	August 29, 2022

How to filter out the zero value from that column?

Related topics