Multi-tab input

Hello,

I have a input data set that is a multi-tab spreadsheet. I used File upload option to import that to Domo. When I am using this in Magic-ETL, I am unable to specify the tab that I need.. What is the way to specify the exact tab I referring to in that spreadsheet. I need to use different tabs for different joins in the same ETL..

Please advise.

Best Answers

  • DashboardDude
    DashboardDude Contributor
    edited May 2023 Answer ✓

    Hi @Aag2023

    When you use file upload, you actually need to select the tab you want to import first. So if you have 3 tabs, you'll have to import each at a time. THEN, at the ETL you can choose that input to use. Same would be with Google Sheets- you have to select the tab you want to import before you use it in the ETL

    John Le

    You're only one dashboard away.

    Click here for more video solutions: https://www.dashboarddudes.com/pantry

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    You can select a specific sheet when you're uploading a file to Domo if it's an Excel spreadsheet and then have multiple datasets for your different sheets and then use those different datasets in your ETL.

    https://domo-support.domo.com/s/article/360043436573?language=en_US

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Answers

  • DashboardDude
    DashboardDude Contributor
    edited May 2023 Answer ✓

    Hi @Aag2023

    When you use file upload, you actually need to select the tab you want to import first. So if you have 3 tabs, you'll have to import each at a time. THEN, at the ETL you can choose that input to use. Same would be with Google Sheets- you have to select the tab you want to import before you use it in the ETL

    John Le

    You're only one dashboard away.

    Click here for more video solutions: https://www.dashboarddudes.com/pantry

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    You can select a specific sheet when you're uploading a file to Domo if it's an Excel spreadsheet and then have multiple datasets for your different sheets and then use those different datasets in your ETL.

    https://domo-support.domo.com/s/article/360043436573?language=en_US

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • A2024
    A2024 Member

    Thank you @DashboardDude and @GrantSmith for the clarification . This is helpful