Issue with changing data type from V_WString to Double

[MackStewart]

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

[BenMoss]

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 

[MackStewart]

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.

[BenMoss]

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.

[BenMoss]

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

[MackStewart]

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

[MackStewart]

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.

[leedransfield]

Hi I have the same issue, but there is no commas in my data - why would this be?

[BenMoss]

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

[leedransfield]