How to select particular tabs in excel

[Rao2821]

I have 2 folders Test1 and Test2. All the files inside Test1 has only 1 tab, so all the files inside Test1 folder runs as expected and generates an combined output. Test2 folder has files with multiple tabs and I want to select only Sheet2 and sheet3 and want Final output of Sheet2 and Sheet3 separately. How can i apply this logic to the workflow i have built ?

[Armon24]

Hi @Rao2821 

Let me point you to this wonderful post by @MichaelAd 

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-To-Import-Multiple-Excel-Sheets... 

[FinnCharlton]

Hi Rao,

There is a macro made by CReW called Wildcard XLSX input, you can download it here: http://www.chaosreignswithin.com/p/macros.html

This allows you to input every sheet of every excel file in a given folder into one datastream. You can also choose to exclude certain sheets, so that you can control which ones are inputted. To output sheets 2 and 3 separately, you could use two tools or simply use a filter tool after the input tool. Hope this helps.

[Felipe_Ribeir0]

Hi @Rao2821 

Take a look at the attached workflow. Just point the directory tool to your source directory and change the filter to filter the sheets that you need.