Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

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