I've read through many discussions, downloaded the Crew Wildcard input macro and still do not know where to begin.
I have a directory of Excel files with the same schema but different sheet names that I want to read in at once rather than updating the workflow with added input file tools each time there are additions.
Please help!
Solved! Go to Solution.
Hi @sonseeahray ,
In this topic, you have a full tutorial with an example explaining how to do it.
I'm also sharing an example of mine with the same idea but different solution.
Let me know if that works for you.
Best,
Fernando Vizcaino
Hi @sonseeahray ,
Since all the files have the same schema, I'm attaching a different and much easier solution.
Take a look and let me know if this makes sense to you.
Best,
Fernando Vizcaino
@fmvizcaino Hi Fernando! I'll take a look now, and also take a look at the link you provided for situations where the files have different schemas. Thanks!
This works so beautifully. I have one file that is giving me an issue but I can bring that one in and modify it.Thank you again!