Reading multiple tabs from the same Excel file dynamically

aliensurfer

Consider the scenario below:

2020.xlsx (Tab1, Tab2, Tab3, …)

2021.xlsx (Tab1, Tab2, Tab3, …)

2022.xlsx (Tab1, Tab2, Tab3, …)

2023.xlsx (Tab1, Tab2, Tab3, …)

.

.

.

I need to read each tab within each Excel file. As of now I have a workflow for 2020.xlsx where I have individual input tools for each tab. How can I make this dynamic in operation so that I can pass the file names (with tab names) to each input tool and run it through the workflow dynamically?

Thanks,

P

Luke_C

Hi @aliensurfer 

You could use batch macros - 1 to get the tab names and 1 to process all the inputs for each tab. Check out this article:

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/ta-p/20480