The solution to last week's Challenge can be found here!
We are thrilled to present another Challenge from our “Think like a CSE” series, brought to you by our fearless team of Customer Support Engineers. Each month, the Customer Support team will ask Community members to “think like a CSE” to try to resolve a case that was inspired by real-life issues encountered by Alteryx users like you! This month, we present the case of using a Wildcard in the Input tool.
Below, we’ve provided the information that was initially available to the Customer Support Engineer who resolved the case. It’s up to you to use this information to put a solution together for yourself.
The Case: We have a co-worker who wants to import all (4) files from one of his folders into the workflow to do some analysis. He doesn’t like the idea of having four Input Data tools in his canvas so he decided to give the “Wildcard” input a try. However, when he runs the workflow, only 1 of the 4 files is imported. Our co-worker is not entirely sure why it’s not working.
Explanation of the Problem: Four input files (attached to this post) exist in the same directory. Our co-worker attempts to bring in multiple .xlsx files into a workflow using a “wildcard” in the input tool:
When he runs the workflow, only one of the four files is imported:
Then, when he clicks the Input tool, an error appears:
What's going on? Can you help our co-worker resolve the case of the Wildcard Input? Download the four attached files, map your Input Data tool to your file location, and give it a try!
Bonus Question: What do you recommend if our co-worker needs to import 60 different files and using wildcard is giving him all these random errors? All these files come from a third party.
The client is so close! However, the input data tool will not read an excel with a tab name that is not consistent with Sheet1. Therefore, when reading the spreadsheet for File4 we see that an error is raised indicating that the file may be corrupted. To facilitate the reading of the different spread sheets with different schemas I would recommend using a batch macro!
Nice challenge. I actually had this exact same scenario on site with a client about 8 months ago, so I've already done this. I assume mine is the same method as the others, as a simple batch macro does the trick.
Great challenge. I've never had to do this but after researching the community for solutions this is what I came up with:
STEP 1: Make a macro to combine the sheets.
STEP 2: Reference this macro in your second macro that reads all the sheet paths.
STEP 3: Reference the macro in STEP 2 to complete the project.
See attached solution files.