Multiple File Input with multiple sheets

pchong

I have files with different dates, each has a few sheets but same columns.

I want to do a dynamic input that combine the rows of a particular sheet (ie sheet1 of all the files)

"*" at the Input tool didn't do the trick.

Any guidance would be much appreciated.

Thank you.

AncientPandaman

you  need to use dynamic input tool.

it a bit tricky, but the way is:

input tool

1. Load list of sheet name instead of Sheet1

2. load full path instead of filename only.

formula tool

1. Replace the "<List of sheet name>" in [Filename] with [Sheet name]

*the name of field and text may not correct. as i do not verify.

dynamic input tool.

1. config is to change full path.

2. sample file, the setting will applied to the output.