Convert string datatype to double datatype

[Carissahjx]

Hi, I imported a csv file into Alteryx, and I want to convert the data under the pay rate field from string datatype to a double datatype. Can anybody provide help please, thank you!

[JamesCharnley · Accepted solution]

Hi @Carissahjx,

The easiest way to change data types is connecting the data up to a Select tool, and then changing the data type to a double in the 'Type' drop down menu. In your case due to the $ sign, you will first have to add a Formula tool with a formula such as Trimleft([Pay Rate], '$')

[Luke_C · Accepted solution]

Hi @Carissahjx 

A replace function followed by a select tool should work:

Replace([Pay Rate],'$','')

[Emmanuel_G · Accepted solution]

@Carissahjx 

Find in attachment the way of doing that.

[Carissahjx]

Hi @JamesCharnley, thanks so much for your solution. It works!

[Carissahjx]

Hi @Luke_C, thanks so much for your help!

[Carissahjx]

Hi @Emmanuel_G, thanks so much for your help!