Exporting Dates to MS Excel
User Story:
As a Data Analyst, I'd like to be able to export Dataiku Datasets into MS Excel files and have the parsed Date Time come through into MS Excel as MS Excel DataTime Columns not Text strings in the style of an ISO Data Time, this would save time and reduce confusion on the part of date consumers.
Notes:
- Problem was discovered in Dataiku DSS V8.0.4
cc: @AshleyW
Comments
-
This would be great! We're also constantly importing and exporting Excel datasets with datestamps at my company. It would be great if both the Excel import and export capabilities could support Excel's DateTime object (64-bit floating point number of days since 1900-01-01 plus a day for the leap year bug in 1900). My team often uses prepare recipes to convert these, but it would be much better if DSS were to natively support them. Even when using a prepare recipe to transform dates to Excel format before export, since we can't set the format hint from Dataiku to indicate that these floating point timestamps should be treated as such, we currently have to open the exported files in Excel and manually format them as dates.
-
tgb417 Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Neuron 2020, Neuron, Registered, Dataiku Frontrunner Awards 2021 Finalist, Neuron 2021, Neuron 2022, Frontrunner 2022 Finalist, Frontrunner 2022 Winner, Dataiku Frontrunner Awards 2021 Participant, Frontrunner 2022 Participant, Neuron 2023 Posts: 1,598 Neuron
Agreed. You understand my pain.
-
AshleyW Dataiker, Alpha Tester, Dataiku DSS Core Designer, Registered, Product Ideas Manager Posts: 161 DataikerHi,
You'll be pleased to hear this idea is in our backlog and we are determining the next steps for development. We can't provide a timeline at this point, but be sure to check back for updates!
For everyone else, kudos the original post to signal that you're interested in Dataiku developing and releasing this! Feel free to leave a comment in the discussion about how this capability would help you or your team.
Take care,
Ashley -
tgb417 Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Neuron 2020, Neuron, Registered, Dataiku Frontrunner Awards 2021 Finalist, Neuron 2021, Neuron 2022, Frontrunner 2022 Finalist, Frontrunner 2022 Winner, Dataiku Frontrunner Awards 2021 Participant, Frontrunner 2022 Participant, Neuron 2023 Posts: 1,598 Neuron
Great News!
-
tgb417 Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Neuron 2020, Neuron, Registered, Dataiku Frontrunner Awards 2021 Finalist, Neuron 2021, Neuron 2022, Frontrunner 2022 Finalist, Frontrunner 2022 Winner, Dataiku Frontrunner Awards 2021 Participant, Frontrunner 2022 Participant, Neuron 2023 Posts: 1,598 Neuron
I ran into this challenge again. Currently using V10.0.3
-
This would be very helpful, most of our exported data goes into Power BI which can handle it just fine. It's the more ad-hoc requests for other stakeholders where this can be a tad frustrating.
Importing the data in excel through Power Query works as a quick fix but not ideal.
-
AshleyW Dataiker, Alpha Tester, Dataiku DSS Core Designer, Registered, Product Ideas Manager Posts: 161 Dataiker
Congrats - we're adding this to our roadmap! While timelines are always tricky, we'll let you know how it's progressing as updates are available.
If you've kudoed the post or added some comments about your particular use case, we may reach out to get some feedback.
Take care,
Ashley -
tgb417 Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Neuron 2020, Neuron, Registered, Dataiku Frontrunner Awards 2021 Finalist, Neuron 2021, Neuron 2022, Frontrunner 2022 Finalist, Frontrunner 2022 Winner, Dataiku Frontrunner Awards 2021 Participant, Frontrunner 2022 Participant, Neuron 2023 Posts: 1,598 Neuron
So glad to hear that this is one step closer to reality.
-
Glad there is a plan to get an update in - same as others on the thread, my team often provides excel exports to stakeholders that don't utilize dataiku directly. In order for dates to be in excel format, we have to go in each time and make the adjustments manually after exporting the excel.
-
tgb417 Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Neuron 2020, Neuron, Registered, Dataiku Frontrunner Awards 2021 Finalist, Neuron 2021, Neuron 2022, Frontrunner 2022 Finalist, Frontrunner 2022 Winner, Dataiku Frontrunner Awards 2021 Participant, Frontrunner 2022 Participant, Neuron 2023 Posts: 1,598 Neuron
It would be nice if the time zone display came threw in local time zone if I wanted as well.
-
Just adding a comment to be able to track the status of this feature request
-
CoreyS Dataiker Alumni, Dataiku DSS Core Designer, Dataiku DSS Core Concepts, Registered Posts: 1,150 ✭✭✭✭✭✭✭✭✭Hi @wjkelly
in the future please feel free to click on the
button on the top right. You can learn more about subscribing to ideas here, as well as . -
Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 1,925 Neuron -
AshleyW Dataiker, Alpha Tester, Dataiku DSS Core Designer, Registered, Product Ideas Manager Posts: 161 Dataiker
We did it!
Your idea has become reality and has recently been delivered in 11.1. As @Turribeach
pointed out, you can find more details in the release notes. In summary, when you now export a dataset to an Excel file, more storage types will be respected between the two: dates, strings with leading zeros, etc.
Take care,
Ashley
