Cant filter datatable by number

Help Studio
1

Hi all

I’m trying to filter a data table column to only show values more than 90, but when I run it, it does not write anything. Some pics below of the filter dt activity I’m using and the column to be filtered (in “general” format)

image
image1512×2016 1.21 MB
image
image1242×2208 940 KB

Any help will be appreciated tks

2

Its working fine at my side look this example
FilterExcel.xaml (7.5 KB) Test.xlsx (9.0 KB)

3

If still not getting share your workflow and file

4

Can’t send my file but I think it’s because it reads the column as text. Is there a way to convert it to int32?

5

then use for each row
then use assign activity
say row(17)=cint(row(17).tostring)
then use filterdatatable

6

I tried doing this and I got this error

image
image3024×4032 3.84 MB

image
image3024×4032 3.92 MB

7

ok nvm i realised it only has an error on empty cells. Thanks so much for your help!

8

Great !

Happy Automation!