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

[digitaldoc]

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

[jonashertz · Accepted solution]

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.

[digitaldoc · Accepted solution]

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-secti...