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.
If it is the same folder, you can bring it in using a wild card folder path\*.xslx
would that work?
unfortunately not
Check out this page:
https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Extracting-all-files-and-all-t...
@mceleaveyhas a tool that I think would help.
Cheers, @LindonB
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.