Combining several files with different sheet names

I have the same file that I receive everyday titled "Aged deal report Open Inventory + AVG Cycle time 05012024" each day the file name changes based on the date. I know how to combine multiple files with like names using a wildcard. However the sheet that I need to pull from these files also changes based on the date. It is titled "OpenInventory05012024." Is there a way to pull these files with different sheet names.

Snip image.PNG

Snip Image 3.PNG

Snip image 2.PNG

Workflow

Accepted answers

All comments

aatalai

If it is the same folder, you can bring it in using a wild card folder path\*.xslx

would that work?

camerynparsons

unfortunately not

LindonB

Check out this page:
https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Extracting-all-files-and-all-tabs-data-saved-on-the-drive/td-p/1179933
@mceleaveyhas a tool that I think would help.

mceleavey

Cheers, @LindonB

camerynparsons

Snip image.PNG

camerynparsons

I was able to select all the data I needed from the directory. However I am still struggling with pulling the sheet name beginning with "Open Inventory" followed by a date in the format mmddyyyy. Can I do anything to pull all the sheets that begin with open inventory.

CoG

Have you tried using 2 Dynamic Input Tools: one to pull sheet names and one to pull data?

If you have multiple sheets, you can throw in a Filter Tool to include only sheets beginning with "OpenInventory". Hope this helps.

Happy Solving!

Sample Workflow.yxzp

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703