I have been trying to understand how I could export an existing DataIku dataset to Excel. By studying the documentation, I suppose there might be an API functionality allowing me to achieve it, but unfortunately I could not find it.
More in details:
I really thank you in advance for any help you may give me.
Exporting to Excel (and to other formats) is available from the right panel on the flow. You have to click on a dataset, then on "Export" at the top of the right panel, and then chose the Excel format.
The dataset will be downloaded as xlsx file.
Thanks a lot for your fast and kind reply.
I apologize if I didn't explain clearly my needs. What I am trying to understand is if there would be a way to access the dataset from Excel (really from the Data -> GetData -> From... tabs), without the need to explicitly connect to DataIku once the dataset has been created and published on the base.
Thanks again a lot and kind regards,
I don't think we have any special integration with Excel apart from export to xlsx files.
However as I can see Excel supports import from SQL server DB, so you may try to write into SQL Server Dataset using your python code in Dataiku and read it by Excel from another end, but without knowing your use case it looks like an overkill.
yes it is possible to export a dataset to Excel. Within your flow, double click on the dataset that you want to export. Select "Actions" in the top right to bring out the panel with options for what you can do with the dataset. There should be an option at the top called "export" -- see image below.
From within the dialogue that pops up, you can select an xlsx format for which to download the data to your local machine. You probably wouldn't want to try this from a particularly large dataset, but I think that should do it for you.