Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Import data from multiple sheets from multiple excel files in multiple different folders

HW1
9 - Comet

I have a parent folder. Within that parent folder, there are multiple folders and within that folder, I have to extract all the sheets data into one big dataframe

 

This is what I mean:

Parent Folder - Multiple folders - Multiple Sheets- Different Schema

 

Extract file namesExtract file names

 

Within these excel files, there are multiple sheets.

 

e.g.

  • "1. Contractor Master File March.xlsx" would contain the sheets "Contractor A", "Contractor B", etc.
  • "1. Contractor Master File February.xlsx" would contain the sheets "Contractor B", "Contractor C", etc.
  • "1. Contractor Master File June.xlsx" would contain the sheets "Contractor A", "Contractor C", etc.

 

I want to extract all the sheets within one table with a column containing full sheet path so that i can then union the respective sheets to create a master information for "Contractor A", "Contractor B", "Contractor C", etc.

 

I have got the file names. Now, I am aware of this example that can read multiple sheets however, every sheet has a different structure and different columns with a very few common columns and column types and thus, I am getting error when I use the Dynamic input tool.

 

How can I get what I want? 

10 REPLIES 10
Qiu
21 - Polaris
21 - Polaris

@HW1 
The data scheme/struture can be different but I observe that the data starts from Row#1 and some starts from #2. That imposes the issue.

Anyway, I used the famaous macro for inputting multiple sheets in multiple files and getting something.

1031-HW1-A.PNG1031-HW1-B.PNG

Labels