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

Alteryx designer Discussions

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

Inputting multiple files in the same directory with the same template but different sheets

Highlighted

Hi, 

 

I'm trying to input multiple files within the same directory and template. However, the sheet names are different so an error is popping up for both ways I've tried to solve it: batch and dynamic input. 

 

Can someone please help? It's urgent.

 

Thank you!

Alteryx
Alteryx

It sounds like you will need two steps. First the Dynamic Input Tool/Batch Macro to get the list of sheet names from each sheet.

 

Then a second to actually read the data with the relevant sheet name being passed through.

 

Do you have examples you can upload?

 

Labels