Import Multiple Excel Files with Varying Worksheets

crunyeon

I am looking to import an entire folder of Excel documents into a workflow without having to add a new input tool for each file.  I tried using a wildcard in the Input field, but I am having a problem.

All of the worksheets within the Excel files are named the same, however they don't all exist in each file.  So for example, they appear like this:

Spreadsheet 1

     West Region Sales

     North Region Sales

     South Region Sales

Spreadsheet 2

     West Region Sales

     East Region Sales

Etc. 

Can I perform an If statement on the import that just ignores the excel file if it doesn't have the appropriate worksheet?  Thank you in advance for your help.

JordanB

Hi @crunyeon

I have attached a workflow built in Alteryx Designer 10.6 which has two batch macros. 

1. The first macro creates a list of all sheets within all excel files

2. The second macro reads each of these files paths (with sheet names) and reads the data into Alteryx.

You will need to update the directory tool and make sure you are reading in xlsx files as that is what this workflow is configured to take.

This should give you the basics if you need to slightly modify for your use case. 

Best,

Jordan Barker

Solutions Consultant

Multiple Sheets_Multiple Files.yxzp