Multi-tab input

A2024

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.

DashboardDude

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

GrantSmith

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

DashboardDude

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

GrantSmith

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

A2024

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