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 · Accepted solution]

---

@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-Exc...

it is super simple and flexible at the same time.

[Priyabrata]

Hi Emil_Kos

Thanks for your help.. Its really working.