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)

image

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:

Cheers

Hey

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.