Ready for Dataiku 10? Try out the Crash Course on new features!GET STARTED

Remove Default Scientific Notation

0 Kudos

Datasets default to outputting numbers in scientific notation, even if the recipe calls for a different format. This is hindersome especially when exporting csv files, as the scientific notation will not be recognized as a number. This forces excel downloads, which are much larger and cumbersome to work with. Having a standard number format default, or having the ability to change default preferences would be very welcome.

2 Comments
CoreyS
Community Manager
Community Manager

Thanks for your idea @mar! Just incase you haven't already seen this, I just wanted to make this resource available to you in our Knowledge Base: How to remove scientific notation in a column 

I hope this helps!

mar
Level 2

Thank you @CoreyS. That helps, but I am working with datasets that have 200+ columns and can't feasibly use this trick for each one individually. Is there a way to more broadly alter the formatting of a dataset?