Designer|Data Import - Numeric Values inconsistency

Hi All,

I have an excel data input sheet has numeric columns. However, some of the rows are being interpreted by Alteryx using scientific notation (eg 5.39..E-2) and some are being read as is (eg 0.108...).

However since any numeric conversion using formula fields such as ToNumber or data field changes affects the entire field and doesn't solve my issue. Essentially, I do not want the scientific notation and want Alteryx to take the input data as is. If that isn't possible, I'd prefer a uniform way of Alteryx interpreting it, i.e., either scientific notation or as is. This way at least I can use fix this across the field.

Any suggestions please?

Input

Accepted answers

atcodedog05

Hi @Mj9715

Here is how you can do it. I am considering only benchmark has a number you can update filter as required.

Workflow:

Hope this helps : )

Numbers format.yxmd

All comments

atcodedog05

Hi @Mj9715

Try using a select tool and converting it to double.

If still facing issue can you provide sample excel file where you are facing the issue.

Hope this helps : )

Mj9715

@atcodedog05 - Unfortunately, te select tool is altering the value by simply dropping the notation instead of dividing it by 100, which is what needs to happen to convert e-2 to a true decimal.

I have attached the file for your reference - as shown below the N column is the one which is being interpreted as a mix of scientific notation and true decimal (As is) when opened in Alteryx.

test inut.xlsx

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703