I am importing an Excel spreadsheet. It has 8 sheets.
Each sheet has a header, and the headers are identical.
I found this tutorial https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-To-Import-Multiple-Excel-Sheets-or-a-Specific-Excel-Range/ta-p/398220
It shows <List of Sheet Names> in the 'Table or Query' name.
When I open my excel file, the middle option 'Select a named range' is grayed out.
I can select one sheet ("Export Worksheet" is the name of the first sheet).
Is there something I need to install to select multiple sheets?
I Select input dialog
What you need to do is select "Import Only sheet names..." then you attach that input tool to a "Dynamic Input" tool to actual read each sheet. I've attached an example workflow for you.
Does anyone have an idea as to how to select only the most recent sheet? I have a workbook that updates daily with the new sheet name being the date it was created. How do I dynamically select the most recent date?
Thanks
