Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Convert scientific numbers
Added on July 31, 2024 8:18AM
Likes: 0
Replies: 3
HL
Registered Posts: 15 ✭✭✭
Hello, I would like to convert numbers in scientific fromat (1,5E7 for example) in a number format (1 500 000,00). Does someone know how to do that ?
Thank you !
Answers
-
Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 2,320 NeuronWhere exactly do you want to convert this scientific number? Is this a data type issue or a display issue? Can you post a sample screen shot of the dataset column value?
-
Here is an example of a number I want to convert in French format
-
Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 2,320 Neuron
The first problem that you have is that is not a number, it's a string as shown in your screen shot. Someone has locked the meaning as well, which is not usually required (read more about storage types and meanings here). So as a first step convert your string into a number. The use the convert number format processor in a Prepare recipe to change the format.
