Import of Multiple Excel Files from SharePoint into Separate Datasets
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?
File Type: Excel
There is no direct link between the files; they have distinct names.