Hi! I would love some help trying to do the following:
I have 5 years worth of monthly data. Each year contains 12 different excel files for each month. Within each month excel file there are 20 tabs for different department P&Ls. Each tab is in the same format
My end goal is to create one file with 20 tabs for each department where each tab has every monthly P&L within it over the last 5 years. Is there a easy way to do this? Each Department should show 60 different periods within the one tab for 2015 - 2020.
THANK YOU for the help!
@Frye2
The input tool allows you to input only Worksheet names, then together with Dynamic Input Tool, it could get what you want.
Hi @Frye2
Give a look into this link
And
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Input-multiple-excel-files/td-p/549984
See whether it helps you out.