topic Relative Path in LOAD statement in QlikView

Relative Path in LOAD statement

Mon, 27 Sep 2010 11:42:56 GMT

How to specify in a LOAD statement, the relative path to an EXCEL file?

Miguel_Angel_Baeyens — Mon, 27 Sep 2010 11:51:47 GMT

Hello Yimen,

One way is doing the following

Directory C:\Level1\Level2; // at the beginning of the script LOAD * FROM ..\..\test.txt; // relative to the Directory set above

Although I always prefer to create variables with paths, then use them in the load statement.

SET vPath = 'c:\Level1\Level2'; LOAD * FROM $(vPath)\test.txt;

Regards.

Mon, 27 Sep 2010 11:53:00 GMT

Hi Yimen,

You just need to check the Relative Path option in the ETL.

Regards,

Raj