Multi-tab input

A2024
A2024 Member
in Magic ETL

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.

Tagged:

Best Answers

  • DashboardDude
    DashboardDude Coach
    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

    Circle.png

    John Le

    Are you on my newsletter? If not, signup here so you don't miss out on my Domo tricks, alerts about my webinars, cooking tips and more

    Signup here:

    https://www.dashboarddudes.com/newsletter

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

    Circle.png

    John Le

    Are you on my newsletter? If not, signup here so you don't miss out on my Domo tricks, alerts about my webinars, cooking tips and more

    Signup here:

    https://www.dashboarddudes.com/newsletter

  • 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

Categories