Is it possible for user to indicate1 file but import all sheets (different schemas)

[AkisM]

Unfortunately I can't use the "import sheet names" and then dynamic input or something like that, both because of different schemas, and also because the file imported is .xls and that doesn't give you the option to import sheet names.

I was thinking something along the lines of, the path that the user enters is saved somewhere, then that path is pasted on the other 3 input tools to import the other 3 sheets, and the sheetname is appended with a formula tool or something (since it is hardcoded and will always be the sheetname).

So does anyone have a workflow idea of how with 1 user file browse tool you can feed 4 different input tools to get 4 different sheets from the same file?

[danilang]

Hi @AkisM 

There's no way to specify a wild card in the sheet name so you'll have to use a technique like this

Get the list of sheet names, find the one with the date info, build a new path with this sheetname and pass it to the dynamic input tool to open the sheet.

Dan

[AkisM]

Thanks Dan!