Convert scientific numbers
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,165 Neuron
Where 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,165 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.