This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
The highly anticipated Alteryx Community tradition is back! We hope you'll join us!
Previously Alteryx successfully converted data type from V_WString to Double.
However, it now delivers this message:
"ConvError: Select (104): Value: 4,912 stopped converting at a comma. It might be invalid."
The raw Excel file has the data format as Custom #,##0;[Red]-#,##0
This has not changed.
The only thing that has changed is the upgrade to the latest version of Alteryx.
Is this a known bug?
I wouldn't necessarily say it's a bug, IMO it's working appropriately, perhaps Alteryx just ammended how they read such errors but I cannot be certain.
I would advise you build a logic to remove commas from the string and then convert to a double datatype.
Thanks for your reply.
My issue is that this worked before.
Now it doesn't.
I have many workflows - I now have to add a function to each one so that I can work around a change that Alteryx has introduced - without a heads up, btw.
The earliest version I can test on is 2018.1 and I note the same behaviour, unfortunately I cannot test on an environment earlier than that.
I just managed to test on 22.214.171.124907 and again get the same behaviour. What version were you using prior to the upgrade?
I'm not 100% sure, but I think it was 11.7.6.
I have tested it in versions 11.7 and the same thing happens.
My very first install was version 126.96.36.199415.
I'm not sure if I have installed upgrades between then and now.
Hi I have the same issue, but there is no commas in my data - why would this be?
Please provide some evidence, or screenshots of your exact error, else it will be rather difficult to identify your issue @leedransfield