Using input Directory and Dynamic input tool with 2 sheets in input

[VMR]

Hi,

I could merge multiple files using input Directory and Dynamic input tool. But when I have two sheets in my input files, I get error. Though I choose one model or example file in Dynamic input tool as a template I get "No specified sheet" error.

Appreciate any help, thanks! 

[DavidP · Accepted solution]

When you have excel files with multiple sheets, you can us a Dynamic Input tool to load the list of sheet names for each and then use a 2nd dynamic input to load each of the sheets - provided they all have the same structure.  Here's an example

[VMR · Accepted solution]

Hi,@DavidP

That's marvellous! thank you much 🙂