Retaining Dataiku format in Excel extracts

aazariaz
Level 2
Retaining Dataiku format in Excel extracts

Hi all -

Is there a way to retain the exact formatting of fields in Dataiku when you export the data to excel?  For example, I have a field called "Cost" and am using the format function to give it two decimal places, like 25.00.  However, when I run the Prepare recipe and export it to Excel, the value is only showing up as 25.

In another field, I also have values that are a mix of numeric and alphanumeric that I'm storing as a string in Dataiku, but when I export it to Excel it is formatting the numeric values as numbers as opposed to text.  Is there a way to have all these values be formatted as text when exporting to excel?

I've attached some screenshot examples here.  Thanks so much for any help!

 

0 Kudos
2 Replies
Jurre
Level 5

Hi @aazariaz ,

concerning forcing Excel to view numeric values as text @tgb417  suggested using an ' as prefix to these values, excel will view them as text then. As i need some extra clarity there i use a prefix-z instead of Tom's suggestion.

With the formatting-challenge i cannot be of help as in my work process all formatting is done in excel when the end product is in excel-format. 

tgb417

@aazariaz ,

If you want to get into coding your own MS Excell export in a Python recipe.  You might be able to use some features of Pandas to do this work.

https://xlsxwriter.readthedocs.io/example_pandas_column_formats.html

One of the lovely things about Dataiku DSS is when you hit a wall.  You can almost always code your way around the problem.

--Tom