Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Import multiple excel files with different sheet names

vdix
7 - Meteor

I am able to use batch macros to input different files with same sheet names, but how do I do it with different sheet names with different files? So i want to be able to pick up a particular sheet among multiple sheets with different sheet names and different file names, the only similarity i can see in the sheet names that i want to input in from all different files is the first word of the sheet name.

2 REPLIES 2
Qiu
21 - Polaris
21 - Polaris

@vdix 
Check this macro. and you can put a filter to retain the worksheets you need.

https://community.alteryx.com/t5/Public-Community-Gallery/Dynamic-Multi-File-Sheet-Names/ta-p/919218

vdix
7 - Meteor

@qiu

Solved earlier issues, it was the formula tool that I added for the condition of the sheet name that was creating problems, replaced it with a filter tool and a formula tool.

 

HOWEVER now the batch macro isn't processing all the files in the directory just returning the output for the file i configured in the macro. 

Labels