Check out the first Dataiku 8 Deep Dive focusing on Productivity on October 29th Read More

Reading Multitab Excel Files Dynamically

Level 1
Reading Multitab Excel Files Dynamically

Hi Team,

I need a help in knowing the procedure to read an excel file with multiple sheets dynamically, i.e. any update in any of the sheet should trigger the flow.

0 Kudos
4 Replies
Neuron
Neuron

@PrakhyathRai 

You may want to check out the ms Excell Plugin.

https://www.dataiku.com/product/plugins/excel-sheet-importer/

Screenshot-2020-03-10-at-15.54.14

 

--Tom
Level 1
Author

Thank You Tom, also had to append another query if it's possible to trigger the flow of execution on changes to any of the sheets of excel

0 Kudos

@PrakhyathRai 

I do not know.  

Let’s see if someone else can respond in that area.  

--Tom
0 Kudos

Hi @PrakhyathRai! Do you want to use an automatic trigger, that automatically detects a change over an excel file? Or it would be acceptable to check every 5 minutes (or any other time frequency) for a change in the excel file?

Also, I'm assuming the excel file is being "downloaded" into dataiku every once in a while? Or is the excel file in a Dataiku Folder in your project?

With that information, and the plugin @tgb417  recommended, I think there is a possible solution to your problem using scenarios. Let me know if I'm understanding well the problem.

Cheers!

0 Kudos