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 
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.