Import of Multiple Excel Files from SharePoint into Separate Datasets

vincent_m
Level 1
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 

input_dataset.PNG

0 Kudos
1 Reply
AlexB
Dataiker

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

 

0 Kudos