This Dynamic input Tool unions on column position meaning the schemas do not need to be the same between files.
Just pass the tool the files location.
If you have any issues please comment below.
Will this tool output the filename? I am currently using the standard Input tool, which has an option to output the filenames as a field. From this, I'm parsing to get a date that is embedded in the filename. The problem I have with the standard Input is that, when I'm using the * wildcard to input multiple Excel files from the same directory, one of them has a column set to v_Wstring instead of v_string, which throws off the input and doesn't import that file. I thought I could use this tool, but I can't seem to find out if it can output the filenames of the files.
Jason
