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 ✭✭✭
in Using Dataiku

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.

· Share on FacebookShare on Twitter

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,601 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

    · Share on FacebookShare on Twitter
  • 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

    · Share on FacebookShare on Twitter
  • 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,601 Neuron

    @PrakhyathRai

    I do not know.

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

    · Share on FacebookShare on Twitter
  • 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!

    · Share on FacebookShare on Twitter
Bookmark this topic

Categories

Setup Info
    Tags
      Help me…