Dynamic Input Issue

[clarrock]

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? 

[apathetichell]

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?

[messi007]

@clarrock,

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

Regards,

[ArtApa]

Hi @clarrock - Hope this post will help: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-convert-from-Scientific-Notatio...