Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

michaelpo
New Contributor III

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

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

1 Solution

Accepted Solutions
michaelpo
New Contributor III

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

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

4 Replies
MVP
MVP

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

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

michaelpo
New Contributor III

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

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

michaelpo
New Contributor III

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

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

MVP
MVP

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

Just like I would have thought