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
SOLVED

Defining a numeric field to double and ended up with conversion errors

Hi all,

 

I am defining a numeric field to 'Double' in the Select tool and ended up with multiple conversion errors with the likes of:

 

Select (41) SUPER: 1,121.28 stopped converting at a comma. It might be invalid.

 

Interesting thing about this error is I don't actually have the 1,121.28 value in my source data.

 

What am I doing wrong??

 

Thanks,

Gundam

Highlighted
ACE Emeritus
ACE Emeritus

Hi Gundam

 

Suggest you slap a regex tool prior to the select tool. 

 

This will allow you to take out any commas.

 

Regex tool setting.JPG

Alteryx Everything, Leave no one behind.
Pulsar
Pulsar

Another easy way to get the job done would be to add a statement in a Formula tool before the Select. Here is an example: REGEX_Replace([Field1], ",", ""). This may be a simple fix if you already have a Formula tool and are looking to keep the number of tools you use in your workflow lower.

Labels