Consolidate multiple excel workbooks having one sheet with different names

Priyabrata

Hi All,

I m very new to alteryx.

I want to develop a workflow with below criteria. Please help me.

1. Multiple excel file with one sheet but sheet name is keep changing from file to file.

2. Sheet is same as the excel file name.

3. File name format is like "ABC.YYYYMMDD.xls", which is changing every day.

I am trying to devlope a workflow which can consolidate a particular date range files into one workbook. Please help me to develop a workflow.

Emil_Kos

---

@Priyabrata wrote:

Hi All,

I m very new to alteryx.

I want to develop a workflow with below criteria. Please help me.

1. Multiple excel file with one sheet but sheet name is keep changing from file to file.

2. Sheet is same as the excel file name.

3. File name format is like "ABC.YYYYMMDD.xls", which is changing every day.

I am trying to devlope a workflow which can consolidate a particular date range files into one workbook. Please help me to develop a workflow.

---

---

@Priyabrata wrote:

Hi All,

I m very new to alteryx.

I want to develop a workflow with below criteria. Please help me.

1. Multiple excel file with one sheet but sheet name is keep changing from file to file.

2. Sheet is same as the excel file name.

3. File name format is like "ABC.YYYYMMDD.xls", which is changing every day.

I am trying to devlope a workflow which can consolidate a particular date range files into one workbook. Please help me to develop a workflow.

---

Hi @Priyabrata,

the easiest way to a achieve that is using this macro:

https://community.alteryx.com/t5/Engine-Works/The-Ultimate-Alteryx-Holiday-gift-of-2015-Read-All-Excel/ba-p/5558

it is super simple and flexible at the same time.