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.
Answers
-
tgb417 Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Neuron 2020, Neuron, Registered, Dataiku Frontrunner Awards 2021 Finalist, Neuron 2021, Neuron 2022, Frontrunner 2022 Finalist, Frontrunner 2022 Winner, Dataiku Frontrunner Awards 2021 Participant, Frontrunner 2022 Participant, Neuron 2023 Posts: 1,598 NeuronYou may want to check out the ms Excell Plugin.
https://www.dataiku.com/product/plugins/excel-sheet-importer/
-
PrakhyathRai Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Dataiku DSS Adv Designer, Registered Posts: 2 ✭✭✭
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
-
tgb417 Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Neuron 2020, Neuron, Registered, Dataiku Frontrunner Awards 2021 Finalist, Neuron 2021, Neuron 2022, Frontrunner 2022 Finalist, Frontrunner 2022 Winner, Dataiku Frontrunner Awards 2021 Participant, Frontrunner 2022 Participant, Neuron 2023 Posts: 1,598 Neuron
-
Ignacio_Toledo Dataiku DSS Core Designer, Dataiku DSS Core Concepts, Neuron 2020, Neuron, Registered, Dataiku Frontrunner Awards 2021 Finalist, Neuron 2021, Neuron 2022, Frontrunner 2022 Finalist, Frontrunner 2022 Winner, Dataiku Frontrunner Awards 2021 Participant, Frontrunner 2022 Participant, Neuron 2023 Posts: 415 NeuronHi @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!