I likely missing something and maybe someone can assist.
Crew macros seem to be really useful but I can't find documentation Wildcard XLSX Input tool. Seems odd a macro is created but not documented. I saw one article where it said look in help which I see but still don't see anything on this particular macro. Odd.
In any case, trying to figure it out by playing with it, I give it a directory I need xlsx files read. It seems to me (someone please guide me) that it looks at all sheets in the workbook and tries to match all workbooks to the first workbook and if it doesn't match it sends the data out the N connector. Trying to figure out how I can use the tool with the following scenario I have a workbook created each day of month. In the workbook it has say 10 sheets each with slightly different columns. What I need to pull together all sheet1s, then pull together sheet2s from each work book and so forth. I see something of a week ago that might help but I'm running 2018.3 and the example is created in a more recent version.
Do I have to pull in all workbooks but exclude all the other workbooks but the one I want? I must be missing the point of the tool.
Any insight appreciated.
Thanks,
Jeff
