Wildcard not working for Excel input

[MansfieldTax]

Good afternoon,

I am using Alteryx to generate EDI files.  Because there isn't a good way I can find to generate the complicated headers of an EDI file using Alteryx's all-or-nothing data table approach, I am grabbing my data in seven separate source inputs (all within the same file) referencing two different tabs, two specific columns in a tab, and three named ranges, and joining them all together in a single column for output as a text file.  It all works well until I attempt to introduce a wildcard into the filename, at which point all my inputs break.  I suspect it might be because I am using Output File Name as Field to pull in the file name only (this is needed to create the output file name as I haven't found a way to introduce one dynamic field into the workflow for the output name - since I have to include everything as columns I'm parsing the dynamic field out of the input filename.)  Hoping someone here has a good idea on how to fix this - really hoping I'm not trying to cram a square peg into a round hole with these EDI files!

[KGT]

Reading through this, I'm not sure what the problem is. When you use a wildcard in the Input Data tool, your inputs don't work? Can you provide an example or a screenshot?

Some things to try,

• Try not outputing the filename, see if your suspicion is correct
• Can you replicate this on a new workflow with one file?
  • If not, then what is the difference.
  • If so, then can you post that example?

Otherwise, more info might be needed.

• Is the error, a "File not found" type of error on the Inputs? 
• What does the filepath look like on the inputs?
• Where is the wildcard going?
• Are the sheets/named ranges quoted?