Same filename with different sheet name every month

Hi,

I receive an xlsx file every month using the same file name with one sheet/tab in the file. The sheet/tab name is different every month. How can I have Alteryx pull in the 1st sheet every month even though the sheet name is different?

Thank you!

Workflow

Developer

Input

Tips and Tricks

Help

Dynamic Processing

Preparation

Accepted answers

allwynthomas24

Hey @Stuart_C,

Please check the attached workflow and confirm whether it gives you the expected output.

Thanks & Regards,

Allwyn

Spoiler

Same Filename Different Sheet Name - Stuart_C.yxzp

atcodedog05

Hi @Stuart_C

Does excel have more than 1 sheet? If not try the attached workflow.

If yes please provide some sample files.

Hope this helps : )

Multiple Excel Sheets Multiple Files (4).yxzp

All comments

Luke_C

Hi @Stuart_C

I'd suggest the following:

Read in the list of sheet names
Use the sheet name to update the full path
Pass that into a dynamic input tool

If you have sample data I can help mock that up

allwynthomas24

Hey @Stuart_C,

Please check the attached workflow and confirm whether it gives you the expected output.

Thanks & Regards,

Allwyn

Spoiler

Same Filename Different Sheet Name - Stuart_C.yxzp

atcodedog05

Hi @Stuart_C

Does excel have more than 1 sheet? If not try the attached workflow.

If yes please provide some sample files.

Hope this helps : )

Multiple Excel Sheets Multiple Files (4).yxzp

SergioCamposs

@Stuart_C

Normally i use this tool, it helps a lot.

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

https://community.alteryx.com/t5/Community-Gallery/ct-p/Community-gallery#!app/Read_All_Excel_Files/58dd51b3a18e9e18fca64172

Stuart_C

Hi @allwynthomas24 . This worked great!

Stuart_C

This worked great when there is only one sheet in the file! It was interesting how if there was more than one sheet, it would combine the sheets into one sheet.