Dynamic Input Issue

Question

Hi,

The excel input file has a column Amount as 409000000

The dynamic input shows as 409.E6 or sometime E-2 for other numbers under this column

How do I convert this to normal numbers and not have E6 or E2?

ArtApa · Answer

Hi @clarrock - Hope this post will help: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-convert-from-Scientific-Notation-E-to-Numeric-Value/td-p/621116

messi007 · Answer

@clarrock,

Could you share a sample data? It will help us to give you the solution.

Regards,

apathetichell · Answer

Question - what's the Type of this output? for me when I type 409.E6 in a text input it's already a numeric type and is a double in select. After a browse it goes to a normal 409,000,000 format. What does your value look like in a browse?