Import of Multiple Excel Files from SharePoint into Separate Datasets

[vincent_m]

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 

 

[AlexB]

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).