Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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
Top Solution Authors