Datatable filter not working with number values

I have created a project where csv data will be stored in a datatable then I will apply filter data from datatable and finally write the filtered data in a new excel sheet.

Filter data table activity is working fine while trying to apply filter on string type data, (like Name = John), but filter data table not functioning while trying to filter data on number values (like Age >= 25). Please suggest if I am doing anything wrong.

Main.xaml (8.0 KB)
project.json (1.6 KB)
Result.xlsx (7.2 KB)


Make sure when filtering numeric data that respective column is realy numeric data type.
Because what looks like a number may not actually be a number :slight_smile:



Try to use LINQ to do it

DT.AsEnumerable.Where(Function(x) CDbl(x("Salary").ToString) >= 50000).CopyToDataTable

That way, even your column is a string it will be converted to Double and then the alue will be checked

Hi @Arijit_Sarkar
Try to downgrade excel package from Manage Packages, it will work, in latest release there are sporadic issues.