Dynamic Input for file and sheet name

Question

I have a Dynamic Input tool that correctly gets a file based on its Creation Time (specified by the user).  Unfortunately, all the files in the target directory have unique Sheet names.

Can I configure the Dynamic Input tool to handle unique sheet names too?  Should I have 2 Dynamic Inputs or something like that?

binu_acs · Answer

@Astrology1901 Try the below batch macro. The first macro reads all the sheet names, the formula tool updates the full path name with the sheets names and the last batch macro combines all the files

Note: you can add the filter tool and the date tool this workflow

CombineFile_190723.yxzp

ChrisWaspe · Answer

Thanks for the workflow. As I cant access your directory and data I can't fully test but I suspect the error you are receiving is just the dynamic input not having any metadata to work off. As you are referencing the result of the Interface tool in your filter formula, you cant test the workflow normally. Please try using the Interface Designer (View/Interface Designer) and running a debug workflow to see if you get the suspected results.

Astrology1901 · Answer

Attached!  Thanks for taking a look

User Input Date - JDE.yxwz