Early bird tickets for Inspire 2023 are now available! Discounted pricing closes on January 31st. Save your spot!

Alteryx Designer Discussions

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

Read in Multiple Excel Files with Different Sheet Names AND Append File Name to Output

kfeng
6 - Meteoroid

Hello! I'm currently trying to bring in 1 sheet from 20 Excel files and all the sheet names are different. I've found macros that could help me do this but once it's done, I can't decipher which Excel file the data is from. Would someone be able to help me configure a workflow that can do this input and also append a field with file name or fullpath? Thank you in advance!

2 REPLIES 2
Felipe_Ribeir0
15 - Aurora

Hi @kfeng 

 

Try to go inside of your batch macro input (you are using this one, right?) and select this red option for the input tool. This will create a column with the filename for you.

 

Felipe_Ribeir0_0-1669906071128.png

 

 

kfeng
6 - Meteoroid

This worked! Thank you so much sir.

Labels