0 votes
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
by

1 Answer

0 votes
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
by
1,296 questions
1,323 answers
1,506 comments
11,862 users

┬ęDataiku 2012-2018 - Privacy Policy