Hello,
I am using a very basic filter and noticed some issues. I am filtering my data on --- [Price] > [Ask_px]
I used a select tool to make sure both the columns' data type is double.
My data is big and more than 90% rows give correct result except some. I am attaching a screenshot of that.
Issue: I am getting some data where my Price = Ask_px.
I tried the same thing on a sample worksheet and the filter works but fails with big data. If I use datatype 'Fixed Decimal' then it worked.
I only have data till 2 decimal places & double should have worked. Can anybody help me understand what is going on?
Extra:
The only unique thing in this workflow is I am getting some processed data from python dataframe with float datatype for Ask_px column which automatically get converted to double when I bring it in alteryx.
