Scientific Notation Issues

Question

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!

Jarrett_Smith · Answer

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

danilang · Answer

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

jossteenso11 · Answer

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

But when I do the ToNumber I still get this: