No reason this should fail. Hits 1+ GB of data, but tiny compared to some problems I've worked with. Crashes anytime I look at the data at any tool. https://www.dropbox.com/s/tybox2qjcn5qhjb/DataIntegrationMetaKagge%20v2.yxzp?dl=0
Solved! Go to Solution.
Is there a particular error that you are getting? My laptop runs this workflow in just under 30 seconds.
Also no issues looking at the data in any of the tools. I am currently running Alteryx 2019.3
Interesting, I was just able to replicate Alteryx closing by clicking on the right anchor of the sort tool. Upon further investigation it looks like the PrivateScoreFullPrecision field is what is causing the issues. When I try to convert it to a fixed decimal I get this: inf is not a valid number
@DiganP this is the workflow that we are taking a look at
Found a way to fix it!!! Set the PrivateScoreFullPrecision to a double instead of a float in the beginning of the workflow.
Nice. Thanks @BrandonB. Nice fix even if it leaves the underlying issue in place. Don't imagine I'm likely to have the same problem again.
I will also forward this to folks who can take a closer look at what is going on. Thank you for reporting this!
I can now, sadly, report that changing the requested field to double does nothing. Still crashes when I look at the outcoming data from Tool 25.
The issue is definitely with the PrivateScoreFullPrecision. Tool 25 as you have it configured creates a new field from PrivateScoreFullPrecision and set it as a float. If you change this data type output to a double as well it fixes the issue.