community
cancel
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

Meteor

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,

Karen

Highlighted
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.

 

replace([field],",","")

 

Ben 

Meteor

Hi

 

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 11.0.6.28907 and again get the same behaviour. What version were you using prior to the upgrade?

 

Ben

Meteor

I'm not 100% sure, but I think it was 11.7.6.

Meteor

I have tested it in versions 11.7 and the same thing happens.

My very first install was version 9.5.10.54415.

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 

SS1.pngSS2.png

Labels