Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

bibopipo
Contributor II

File path

Dear all,

Into my qlikview document, I load a text file:

LOAD @1

FROM

ra_appstart.txt

(txt, codepage is 1252, no labels, delimiter is '\t', msq);

and I don't note any trouble.

I copied all the document into the mounted folder on server, and my qlikview doc. don't find the mentioned file.

I've two possibilities:

- I insert the complete path into my document (e:\mainfolder\ra_appstart.txt)

or I've to copy the file into the mounted folder.

Is there a better solution ? I don0t like to insert the complete path and it's not good for me file duplication.

Help!!

Thanks in advance

2 Replies
MVP
MVP

Re: File path

I am not quite sure I understand, you 'copied all the document into the mounted folder on server' means that you copied both the .qvw file and the .txt file or only the .qvw file into that folder?

If you only copied the .qvw file, how is QlikView supposed to know where to look for the .txt file if it's not located in the same folder?

I believe you somehow need to tell QV the directory to look for that file, i.e. by giving the complete path (in the LOAD statement or using a DIRECTORY statement).

Why don't you like to insert the complete path?

(I think you don't ask for how to use a relative path here, do you?)

Regards,

Stefan

bibopipo
Contributor II

Re: File path

Hi Stefan,

I checked relative path, but it doesn't work how I would like. IS there other options to activate this function ?

For example, on my pc I'm working with path like c:\myfolder\...

but on server I've to place all the documents into another unit and the path is e:\myfolder\...

Entering the path in the document, I always have to remember to change it.

Is it possible to skip this step ?


Thanks for your help and suggestions

Stefan

Community Browser