Hi All,
I have 3 types of file to import daily in my workflow.1 .CSV
2 .XLS
3 .XLSX
Each file has different sheet names everyday. How do I import them as there is no option to wildcard sheet name.
@echuong1 and @T_Willins
I happened to use the below and it worked perfectly fine for me.
This would really only be an issue for the Excel files. You can read in the files as only the list of sheet names and paths. From there, you can use a dynamic input to read in the sheet.
Take a look at the tool mastery series for more information:
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Dynamic-Input/ta-p/24946
Hi @echuong1
I tried almost everything. nothing helps!
Do you have any update? As when Allteryx will implement wildcard in sheet names?
Are you able to upload a copy of your dataset?
Due to data confidentiality, I could not share the exact dataset.However, I have created my own dataset with different sheet names.
Hi @VEDH,
Thanks for providing a sample dataset. It makes it easier to give a complete workflow. Attached is a solution to your issue using a Batch Macro. The workflow uses a Directory tool to find all the .xlsx files in a given folder. The macro then looks at each FilePath one at a time to find the worksheet(s) in each workbook, adds the worksheet to the filepath, then uses a Dynamic Input tool to read the data from the worksheet(s). It loads the data for each worksheet in each file, then outputs all the data to the Macro Output. This will work as long as all the worksheets have the same schema (same columns, columns have the same datatype in each file). Let us know if you have questions or need additional assistance.
Batch Macro
Workflow
