Exporting Dates to MS Excel

Options
tgb417
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,595 Neuron

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

6
6 votes

Released · Last Updated

Comments

  • natejgardner
    natejgardner Neuron, Registered, Neuron 2022, Neuron 2023 Posts: 151 Neuron
    Options

    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
    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,595 Neuron
    Options

    @natejgardner
    ,

    Agreed. You understand my pain.

  • AshleyW
    AshleyW Dataiker, Alpha Tester, Dataiku DSS Core Designer, Registered, Product Ideas Manager Posts: 161 Dataiker
    Options

    Hi,

    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
    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,595 Neuron
    Options
  • tgb417
    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,595 Neuron
    Options

    I ran into this challenge again. Currently using V10.0.3

  • TS3392
    TS3392 Registered Posts: 1 ✭✭✭
    Options

    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
    AshleyW Dataiker, Alpha Tester, Dataiku DSS Core Designer, Registered, Product Ideas Manager Posts: 161 Dataiker
    Options

    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
    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,595 Neuron
    Options

    @AshleyW

    So glad to hear that this is one step closer to reality.

  • rl_wsmith
    rl_wsmith Registered Posts: 1 ✭✭✭
    Options

    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
    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,595 Neuron
    Options

    It would be nice if the time zone display came threw in local time zone if I wanted as well.

  • wjkelly
    wjkelly Registered Posts: 22 ✭✭✭✭
    Options

    Just adding a comment to be able to track the status of this feature request

  • CoreyS
    CoreyS Dataiker Alumni, Dataiku DSS Core Designer, Dataiku DSS Core Concepts, Registered Posts: 1,150 ✭✭✭✭✭✭✭✭✭
    Options

    Hi @wjkelly
    in the future please feel free to click on the

    Screen Shot 2022-08-20 at 6.15.17 PM.png button on the top right. You can learn more about subscribing to ideas here, as well as .

  • Turribeach
    Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 1,744 Neuron
    Options
  • AshleyW
    AshleyW Dataiker, Alpha Tester, Dataiku DSS Core Designer, Registered, Product Ideas Manager Posts: 161 Dataiker
    Options

    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

Setup Info
    Tags
      Help me…