Scientific Notation Issues

[jossteenso11]

Hello all!

 
I am having some issues with a CSV file I am trying to upload.

The original CSV looks like this:  

In the manual process it, the first step is to import this file into Excel through text legacy and the file looks like this:

The zeros disappear from the scientific notation disappears and the correct numbers are being added rather than zeros.

How can I replicate this in alteryx? It has to be an import issue as no matter what else I do after import all I get is the non scientific notation with zeros filled in rather than proper integers.

What can I do to help fix this problem?

Any help would be greatly appreciated!

[binuacs]

@jossteenso11  you can convert the data type into double to get the data without e-notation

[jossteenso11]

The problem I have is I need my number to look like this:

But when I do the ToNumber I still get this:

[danilang]

Hi @jossteenso11 

I believe that the issue is caused because you have an intermediate step going through excel.  Try importing the original .csv directly into Alteryx.  If this doesn't work, post a sample .csv file here.

Dan

[Jarrett_Smith]

Hello - I am having this exact same issue (part of the full number is being cut off) - was this issue ever resolved? Any tips/workarounds? Thanks