Wildcard suddenly stops working (Excel files)

Alter_X

Hi,

hope everybody is well! I see many threads about the wildcard but I couldn't find any matching my case (correct me if I'm wrong):

We developed an Alteryx flow and used the wildcard to simultaneously read in several inputs. This worked perfectly until one day it suddenly did not.

The files have exactly the same columns (+ headers) etc. We even restored the old files where it was working the week before but now it's somehow broken.

Has anybody else made the same experience? We are not looking for solutions with macros or anything like that. The preferred solution is that the wildcard works as before.

Example:

Files:

Test_1

Test_2

...

Path:

....\Folder\Test*.xlsx

Thank you very much in advance!

wdavis

Hi @Alter_X 

No problem, the message is enough to help here. 

The difference in schema can relate to a couple of matters;

- Difference in Columns between files

- Difference in Data Types between files

If you want to bring both input files in as normal inputs, you would be able to then look at the metadata (Using a Select Tool is probably easiest) and compare the 2 files to see what the difference between the files is.

Let me know if that helps

Kind Regards,

Will