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 · Accepted solution]

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/t...

[aliensurfer]

Thanks @Luke_C. This solution might prove useful.