Convert string to number with 4 decimals places.

[RichardAlt]

I have a problem converting the string to a number.

I have this sample dataset.

Col1	Col2	Col3	Col4	Col5	Col6
ISIN	Price	Net	ISIN	Price	Net
	USD	SGD		USD	SGD
			LU2211955666	10.38	0.04
			LU2211955310	15.41	0.05
			LU2211955740	10.83	0.05
			LU2211955823	10.38	0.04
			LU2211956045	10.81	0.05
LU2230392941	95.17	-0.16
LU2275027386	14.82	-0.04
LU2106585644	100.09	-0.28
LU2106585560	102.48	-0.3
			LU2106585727	100.53	-0.3
LU2106585487	102.36	-0.29
LU2106586378	101.93	-0.73
LU2106586022	101.72	-0.73
LU2106586535	103.91	-0.75
LU1675844036	96.94	-0.15
			LU1720897476	89.05	-0.15
LU1675843905	14.31	-0.02

I just want to convert col2-col3 and col5-col6, but when I insert Select Tool and change the datatype to FixedDecimal 19.4, Yes It converts the number but the text like SGD, USD and other text in that columns becomes null.

[binuacs]

@RichardAlt Alteryx don't support multiple data types in one column. 

[TheOC]

hi @RichardAlt 

Sorry to hear about your issue.
if you set a field to a numeric, all string data from that field will be lost. mI would recommend making the text in this data within the column headers:

Please see attached solution

Cheers,
TheOC