Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.

Grabbing data multiple sheets from multiple workbooks into one workbook

Highlighted
5 - Atom

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

Highlighted
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.

Highlighted
5 - Atom

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!

Highlighted
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