Combine multiple excel sheets to one and adding sheet name

[Wojtek_Dz]

Hello, how to combine multiple excel sheets to one and adding sheet name for data where there come from ?

Input:

  

Expected result

Source file below 🙂

[atcodedog05 · Accepted solution]

Hi @Wojtek_Dz 

Here is how you can do it.

Workflow:

1. You can use a combination of input tool get sheet names and dynamic tool to read multiple sheets. You can refer the below link to get to know more about this.

https://community.alteryx.com/t5/Interactive-Lessons/Connecting-to-Multiple-Sheets-at-Once/ta-p/8287... 

2. In dynamic input tool template you need to set output file name option as full path so that you get the sheets.

3. Dynamic input tool will read all sheets and give you the data with full path. I am using regex formula in formula tool to get only the sheet names (this formula will work for most scenario to get sheetname from full path)

Hope this helps 🙂

[Wojtek_Dz]

Great, it works.

Thank you 🙂

[minhdvo]

Thanks.