cleaning the data

[rag329]

i have the data 0.000+E0 and 1.000+E0 in one of columns but when I read it in alteryx it shows as 1 ,, i need it to be read as same as the original.... please help

[Deano478]

@rag329 what datatype is it being read in as and what datatype should it be?

[rag329]

It is in numeric data type and need it in the numeric only

@Deanon47

[rag329]

It is in numeric data type and need it in the numeric only

@Deano478 

[rag329]

It is reading as double

[Deano478]

@rag329 I could be wrong but I'm 90% sure Alteryx will read this is in as a string and to get these values into numbers you wont be able to keep the original formatting 

[rag329]

Yes, even I wonder it took as double becase when I read the data defaultly it shows as 1 instead of 0.000E+00 thats why it shows as double... if alteryx reads 0.000E+00 then it will read as string... @Deano478 

[Deano478]

@rag329 Technically 1 and 0 are right because thats what those values will amount to just without the notation

[rag329]

Thank you @Deano478 .