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
asked 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
answered by
893 questions
923 answers
905 comments
1,430 users