topic "Field not found error" but Field is in Source File in App Development

"Field not found error" but Field is in Source File

digitaldoc — Thu, 18 Jan 2024 14:05:21 GMT

Hi all,

I have a very strange error. I shortened the paths with "....."

I am trying to load a csv file with this load statement:
LOAD
'USER' as ACCESS,
[Mitarbeiter] as NTNAME,
upper([LDAP ID]) as %KEY_MITARBEITER
FROM
[.....\Benutzer.csv]
(txt, utf8, embedded labels, delimiter is ';');

The file "Benutzer.csv" contains this:
Mitarbeiter;Benutzername;LDAP ID;aktiv
0;Test;;ja

I get this message:
File not found error
Cannot open file: '.....\Benutzer.csv'
System error: Filesystem::FindImpl FindFirst call
LOAD 'USER' as ACCESS,
[Mitarbeiter] as NTNAME,

upper([LDAP ID]) as %KEY_MITARBEITER

FROM

[.....\Benutzer.csv]

(txt, utf8, embedded labels, delimiter is ';')

What is wrong here?

Thanks and best regards

Re: "Field not found error" but Field is in Source File

jonashertz — Thu, 18 Jan 2024 14:32:23 GMT

The error message say FILE is missing not FIELD? 🙂

And it does look like your relative path is not correct. If you need to point to a directory 3 levels up try ..\..\..\Benutzer.csv if two levels up try ..\..\Benutzer.csv.

For more information about relative paths see this thread.

Re: "Field not found error" but Field is in Source File

digitaldoc — Thu, 18 Jan 2024 14:47:59 GMT

Thanks for the reply. I copied the wrong message.

I found the solution in the meantime by trying a lot.

Actually the error was, that the section access requires all uppercase field names in the source file.

https://community.qlik.com/t5/QlikView-App-Dev/All-field-names-must-be-written-in-uppercase-in-section-access/td-p/1339865