Relative Path in LOAD statement

[#1]

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

[Miguel_Angel_Baeyens]

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.

[#3]

Hi Yimen,

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

Regards,

Raj