Excel number format in Dataiku

pi_485
Level 2
Excel number format in Dataiku

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,

0 Kudos
1 Reply
sergeyd
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.