I have an excel file with multiple sheets in it. How can i load all the sheets in table

Matillion ETL
1

Hi ,

I have an excel file stored in gcp bucket and it contains lot of sheets. I want to load all of them in a single BigQuery table .

 

Please advice

 

Thanks

2

Hello @gopal.suri​

Thanks for your question, I wanted to share some information that should help you with this, first of all, there is the Excel Query Component I wanted to also share the full documentation for this too, these should help you achieve what you are trying, if you are still unable to, please let me know and we can take a closer look.

Kind regards, Joe