Field Not Found - Data Load - * versus no * - Debugging

[Anonymous]

Hello,

First load works (exact filename).  No errors.  Second doesn't and it creates an error (Field not found, Field X not found) when I use the '*' character.

Essentially everything is the same except I use the '*' in the Second and it's unclear to me what's causing the error.  I'm having difficulty debugging this scenario. Any insight on best practices when it comes to debugging would be much appreciated.  I noticed several items posted on this topic but none of the items helped (or I didn't find it).

First:

Load

     Field 1

     Field 2

FROM [FILE Location\Filename1234.csv]

(txt, codepage is 1252, embedded labels, delimiter is ',', msq)

Where Field_X...

Second:

Load

     Field 1

     Field 2

FROM [FILE Location\Filename*.csv]

(txt, codepage is 1252, embedded labels, delimiter is ',', msq)

Where Field_X...

Thanks,

Michael

[sunny_talwar]

Do you have Field 1 and Field 2 in all the files sitting at the location?

[Anonymous]

Yes.  The fields are identical for all files.  This has been confirmed.  Thanks for the question.

[Anonymous · Accepted solution]

Inspected my files again and found a file that was empty.  This caused the error.  Thanks for the feedback.

[sunny_talwar]

Just like I would have thought