What are the steps to refresh an excel file?
This should be really simple… None of the steps I have found online work.
Answers
-
that does not work at all
-
The data set has 30 rows. Two columns. I want to update the excel file in Dataiku. There really should be a button that says refresh data.
-
Auto refresh does not work. Rebuilding the file is the worst answer I could think of. How could you roll out this software without the ability to refresh an excel sheet? Makes no sense.
-
I have been told that I am not able to refresh an excel document. I will have to recreate the dataset and then replace it within the workflow.
-
That might depend where the Excel file is and how it's used.
I frequently use Excel files as reference/mapping tables in my flows. The files are stored in OneDrive or Sharepoint (I'm sure other online services would work but I haven't tried others). Dataiku reads the file when the scenario is initiated or I manual run a flow that uses that input.
The only time I can't refresh is if I upload an Excel file from my computer.
I hope that helps!
-
Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 1,981 Neuron
Whoever told you this is not right. Refreshing an existing XLS is possible but it will depend on where this XLS is stored. In order to be able to refresh an XLS without having to upload it again you need to store in a technology that allows to save files like a Dataiku managed folder. This managed folder can be stored in local storage, network storage or Cloud Bucket Storage. Once you upload your XLS to this managed folder you can "refresh" the data using a File in Folder dataset which loads the latest XLS into a dataset. Another way to do this is via a Python recipe.