Hi Community,
I would like to ask how we import certain tabs (two or maybe more) into excel file ?
Thank you.
Hi @SH_94,
You can check this post:
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Combining-multiple-excels-into-one-workbook-with-multiple-tabs/m-p/576429/highlight/true#M126948
If I understand you correctly you want to import all sheets from one excel file. If that is the case there is a workflow that should help you.
Hello @SH_94 ,
To import the information from multiple tabs from the same excel file using the dynamic input tool for example you need to be sure first if all sheets have the same structure (same name columns, same data type)
If the data is not the same or you cannot assure that it will be then we would need to take another approach.
Could you please tell me what it is in your case?
Regards
Hi @ afv2688,
I have three excels which meet both scenario: two excel file ( multiple tab with the same structure) and another one excel file (Multiple tab with different structure) .
Could you please advise me on both ?
Also, can i ask you whether i able to build the workflow the creating additional column which will follow the name of the tab in excel file (after importing the excel data)?
