Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
We will be upgrading the Gallery to our 2019.4 release this Saturday, December 7th beginning at 9:00am MT. We expect the outage to take last approx. 2.5 hours.

Issue with changing data type from V_WString to Double


Version: 2018.2.5.48994


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?


Many thanks,


Alteryx Certified Partner
Alteryx Certified Partner

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.

Alteryx Certified Partner
Alteryx Certified Partner

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.

Alteryx Certified Partner
Alteryx Certified Partner

I just managed to test on 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

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?

Alteryx Certified Partner
Alteryx Certified Partner

Please provide some evidence, or screenshots of your exact error, else it will be rather difficult to identify your issue @leedransfield