Import of Multiple Excel Files from SharePoint into Separate Datasets
Hello,
I have a folder connected to a SharePoint containing multiple files inside. I would like to import all the files present in the folder at once into different datasets. Currently, I perform the action manually by importing Excel datasets one by one into my Flow. However, due to the increasing number of files in my SharePoint, I would like to automate this process.
How can I achieve this automation in Dataiku DSS? Are there any plugins or scripts that can help me import all files from the SharePoint folder into separate datasets seamlessly?
Additional Information:
- File Type: Excel
- There is no direct link between the files; they have distinct names.
- I'm using Dataiku version 11.
Thank you
Answers
-
Hi !
You could try the Excel sheet importer plugin. It is a macro that can exact all excel files present in a folder and create as many datasets in your flow than necessary (one per file - sheet).
