Filtering for "Comes After" not populating correctly?

jason79121

Hello,

I am trying to perform a filtering using the "Comes After" functionality in the Filter tool. I have a data type for "NumberOfDaysOpen" for V_WString, and I am seeing that the tool is not working as intended as there are outputs of 621 showing up in the False.

Ideally I would want anything larger than 30 to show up in the "True" output. Does anyone know what I may be doing wrong or if there is another way to do this?

Alteryx Question.PNG

DataNath

Hey @jason79121, you're currently trying to apply a mathematical operator/check (> 30) to a string value. If you want this to work correctly you'll have to do one of 2 things:

1) Add a Select tool before the filter and change your [NumberOfDaysOpen] to something numeric (integer, double etc)

or

2) Use the ToNumber() function to temporarily convert the data type for the duration of the Filter check, which would look like:

ToNumber([NumberOfDaysOpen]) > 30

Hope this helps!

Quick edit: One thing to note is that - from your screenshot - it looks like you're looking at the False results of the Filter tool after the '> 30' check. Though you do have results both above and below 30 which shows the initial Filter isn't working, should be addressed by the above.