Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Force text type in Excel export
Added on February 1, 2018 10:03PM
Likes: 0
Replies: 1
Pierre_Desjardi
Registered Posts: 2 ✭✭✭✭
Bonjour,
I am trying to export a file with a column of IDs, that Excel interprets as number (even if the type is string / Text in Dataiku).
e.g. -2.876553E16 --> 25561367.87 (Excel believes it is an exponential)
e.g. some #DIV/0! occurs also
How can I force this column to stay in text when I export ?
Thank you !
Pierre
PS: I did a fix by adding a letter before all the IDs and removing in excel, but there is a probably a easier way to do it
I am trying to export a file with a column of IDs, that Excel interprets as number (even if the type is string / Text in Dataiku).
e.g. -2.876553E16 --> 25561367.87 (Excel believes it is an exponential)
e.g. some #DIV/0! occurs also
How can I force this column to stay in text when I export ?
Thank you !
Pierre
PS: I did a fix by adding a letter before all the IDs and removing in excel, but there is a probably a easier way to do it
Answers
-
Hi,
As of today, our Excel export feature uses the type inference mechanism of pandas. This explains why the ID column was converted to a numerical one in the file export.
Thanks for pointing it out, we will see how we can improve this in future releases.
Cheers,
Alex
