Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Convert 1.248e+006 to a number

Saagar
7 - Meteor

Hi 

I am new to alteryx and still learning

How can I convert a string value 1.248e+006 to a number, I have prices of certain items but some rows have values like 1.248e+006 

attached is a sheet 

 

Thanks in advance

2 REPLIES 2
Qiu
21 - Polaris
21 - Polaris

@Saagar 
We can do some conversion as below

0313-Saagar.PNG

Qiu
21 - Polaris
21 - Polaris

@Saagar 
Thank you for accepting my solution.

Labels