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?
