How to select particular tabs in excel

Question

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 ?

Felipe_Ribeir0 · Answer

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.

Batch Macro Workflow.yxzp

FinnCharlton · Answer

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.

Armon24 · Answer

Hi @Rao2821

Let me point you to this wonderful post by @madler_alteryx

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-To-Import-Multiple-Excel-Sheets-or-a-Specific-Excel-Range/ta-p/398220