Same filename with different sheet name every month

[Stuart_C]

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!

[Luke_C]

Hi @Stuart_C 

I'd suggest the following:

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

If you have sample data I can help mock that up

[allwynthomas24 · Accepted solution]

Hey @Stuart_C,

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

Thanks & Regards,

Allwyn

Spoiler

[atcodedog05 · Accepted solution]

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 : )

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

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

[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.

[atcodedog05]

Hi @SergioCamposs 

Thanks for sharing the links they are definitely helpful 🙂👍

Cheers and have a nice day!

[Stuart_C]

Hi @Luke_C .  Thank you for the instructions.

[atcodedog05]

Hi @Stuart_C 

Yes, This workflow is to read multiple excel multiple sheets. This is helpful when the schema is different.

Happy to help : )

Cheers and have a nice day!