Excel number format in Dataiku
pi_485
Partner, L2 Admin, Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS Core Concepts, Registered Posts: 6 Partner
We have a column that contains data in 52,136,999.976 format in Excel. When exported to Dataiku, data becomes, 5.2136999976E7. How can I represent this value in 52136999.976 math number format (without commas).
Thanks,
Answers
-
Sergey Dataiker, Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS Core Concepts Posts: 365 Dataiker
Hi @pi_485
By default, DSS will display numbers in the scientific notation above a certain threshold and this is not configurable. However, you should be able to remove the scientific notation for numbers by using the format() function in a formula via a prepare recipe as described here:Hope you will find this useful.