community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

Issue with changing data type from V_WString to Double

Meteoroid

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

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 

Meteoroid

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

Meteoroid

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

Meteoroid

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