Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
digitaldoc
Contributor
Contributor

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

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
Labels (1)
2 Solutions

Accepted Solutions
jonashertz
Contributor III
Contributor III

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.

View solution in original post

digitaldoc
Contributor
Contributor
Author

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

View solution in original post

2 Replies
jonashertz
Contributor III
Contributor III

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
Contributor
Contributor
Author

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