Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
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.
You may want to check out the ms Excell Plugin.
https://www.dataiku.com/product/plugins/excel-sheet-importer/
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
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!