topic Re: Field Not Found - Data Load - * versus no * - Debugging in App Development

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

Anonymous — Wed, 24 Jan 2018 18:37:32 GMT

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

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

sunny_talwar — Wed, 24 Jan 2018 19:01:15 GMT

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

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

Anonymous — Wed, 24 Jan 2018 19:25:13 GMT

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

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

Anonymous — Thu, 25 Jan 2018 18:44:57 GMT

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

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

sunny_talwar — Thu, 25 Jan 2018 18:45:58 GMT

Just like I would have thought