reading files from directory, missing 1 file from being read

[wonka1234]

Hi,

I am using the input data tool to read a bunch of similar structured files.

ie  \\Alteryx\Community\*.xlsx.

Sheet name : Wires.

Why is this only reading 24 of 25 files in?

The sheet name is consistent and the file itself is an .xlsx and it is not locked.

How can I debug this and get my missing file?

[n8rushton]

Is the file empty?

I would double check that the schema of the od-ball file is matching the others. If so, I would double check the file name/sheet name. 

This sounds like a naming convention issue.

Would it be worth trying to do a dynamic input off a directory instead of a *.xlsx?

[wonka1234]

@n8rushton  I can read the file fine when it is the only file in the directory though.. very odd.

[n8rushton]

@wonka1234 This makes me think that the schema of the files you are bringing in do not match. Check to make sure that odball has its columns/fields written out the same.

[wonka1234]

@n8rushton  what could schema entail? like headers?

[n8rushton]

Yes, if the headers are mixed in the entities, it will not want to open from a wildcard.