community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Grabbing data multiple sheets from multiple workbooks into one workbook

Hi, I'm very new to Alteryx and I was hoping for some guidance on how to complete this task.

 

I have a folder of files, all the same structure (Year1.xlsx, Year2.xlsx, Year3.xlsx for example purposes). Each of the files has sheets related to different stores (A,B,C,D,E). I'd like to go through each of the files and grab the yearly revenue from each of the stores (in the Year _ column) and create a master sheet for each store in the Expected Result.xlsx.

 

Thanks for the help, it's much appreciated

Inactive User
Not applicable

Download the CreW Macro pack and use the dynamic XLSX input tool. That will bring in all workbooks and sheets. Then apply your transformations to get the total revenue.

Hi, thanks for the reply. I downloaded the macro pack and I'm still confused as to how to go about this, mainly how to even set it up. I'm very new to alteryx so this would be a great help, thanks!

Inactive User
Not applicable

This tool is directory-based you just drop the files into a directory select that directory with the tool and it pretty much does the rest when you run it.

Labels