I’m trying to do a very simple filter on a datatable where the value in a column needs to be bigger than a certain value and I want to remove the rest.
When I apply the filter all the rows are removed. It’s driving me nuts as this should be very simple!
Attached is the workflow I am using. I don’t want a working workflow I need to understand why my workflow isn’t working. Maybe it’s the data from the excel file if so that is the format it comes in from a data scrape so if that is the problem I need to understand how to fix the data. If it isn’t the problem I need to understand what I’m doing wrong in the filter activity.
The data is in an excel spreadsheet in the data folder
FilterTest.zip (11.4 KB)
Thanks for any help on this matter. I am pulling my hair out!!!