Community Conundrum 27: Stacks of Questions is live! Read More

How to replace scientific notation

Level 1
How to replace scientific notation

Bonjour,



I have a dataset with scientif value , i can't find the solution to convert them in numeric.





 



Thanks

0 Kudos
6 Replies
Dataiker
Dataiker

Maybe using the "Formula" processor? See here.

Jeremy, Product Manager at Dataiku
0 Kudos
Level 3

Hi,

is there any update on this topic? The scientific value appears in SQL notebooks as well as when connecting to the SQL DB. Even though in the SQL DB the value appears correctly.

In my case, the prepare recipe with formula does not affect the output formatting. 

Thank you for any help!

Best regards,

Romana 

0 Kudos
Community Manager
Community Manager

Hi @Romana we actually wrote a Knowledge Base article on this topic: How to remove scientific notation in a column.

I hope this helps!

Don't forget to mark as "Accepted Solution" when someone provides the correct answer to your question.
0 Kudos
Level 3

Hi @CoreyS ,

thank you for your reply. Unfortunately this does not work.. 

In the prepare recipe after applying formula the value looks OK "54555139.94" but in the actual output of the prepare recipe the value is shown again as "5.455513994E7" . The formula I use is: "format("%.2f", numval("column name"))"

Also this does not really solve the issue when I want to explore values stored in SQL DB and I only want to create a new dataset without any visual recipes. 

Level 2

Can confirm that this solution does not work, I am having the same problem as Romana. 

0 Kudos
Community Manager
Community Manager

@Romana @Joeiku Here is another thread where an answer to your issues should apply. I've spoken with Makoto and he confirmed that this solution should apply: https://community.dataiku.com/t5/Using-Dataiku-DSS/Scientific-Notation-not-removed-by-format-functio... 

Don't forget to mark as "Accepted Solution" when someone provides the correct answer to your question.
0 Kudos
Labels (2)