Reading Multitab Excel Files Dynamically

PrakhyathRai
PrakhyathRai Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Dataiku DSS Adv Designer, Registered Posts: 2 ✭✭✭

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
    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
  • PrakhyathRai
    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
    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

    @PrakhyathRai

    I do not know.

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

  • Ignacio_Toledo
    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 Neuron

    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!

Setup Info
    Tags
      Help me…