topic Re: Relative Path in QlikView

Relative Path

varunreddy — Fri, 08 Jan 2016 18:00:13 GMT

Hi guys,

How can we make this relative path?

'\\hbeu.adroot.hsbc\dfsroot\GB002\GDMP\01.GDMP\04. Data Quality\25. Data Quality Metrics & Reporting\98. Reporting\DQ_Qlikview\UAT\Config\KeyFile.txt';

Thanks in advance!

Cheers,

Varun

Re: Relative Path

swuehl — Fri, 08 Jan 2016 18:04:03 GMT

I am missing the path in your request that you want to use as base for the relative path, i.e. the start pointing of the relative path. Or in other words: "relative path to what"?

Re: Relative Path

varunreddy — Fri, 08 Jan 2016 18:15:40 GMT

Relative to

'\\hbeu.adroot.hsbc\dfsroot\GB002\GDMP\01.GDMP\04. Data Quality\25. Data Quality Metrics & Reporting\98. Reporting\DQ_Qlikview\UAT\Config

Re: Relative Path

sinanozdemir — Fri, 08 Jan 2016 18:16:18 GMT

If you are asking about making relative paths, then here is how you do it:

Directory \\hbeu.adroot.hsbc\dfsroot\GB002\GDMP\01.GDMP\04. Data Quality\25. Data Quality Metrics & Reporting\98. Reporting\DQ_Qlikview\UAT\Config;

Then in your load script, you can directly put the file name:

LOAD

FROM KeyFile.txt;

Another example is that we can only specify the directory to include upto DQ_Qlikview folder:

Directory \\hbeu.adroot.hsbc\dfsroot\GB002\GDMP\01.GDMP\04. Data Quality\25. Data Quality Metrics & Reporting\98. Reporting\DQ_Qlikview;

In the load script, we put ..\ to move into the next folder:

LOAD

FROM ..\..\KeyFile.txt;

Pretty much ..\ helps you move up and down in the folder hierarchy.

Hope this helps.

Re: Relative Path

swuehl — Fri, 08 Jan 2016 18:17:09 GMT

So the file is located within the base folder?

'.\KeyFile.txt'

Re: Relative Path

varunreddy — Fri, 08 Jan 2016 18:19:59 GMT

Trying something like this. But it is not working

Re: Relative Path

varunreddy — Fri, 08 Jan 2016 18:20:18 GMT

Trying something like this. But it is not working

LET vKeyFileLocation = '..\KeyFile.txt';

Re: Relative Path

swuehl — Fri, 08 Jan 2016 18:23:46 GMT

'..\' will use the parent folder of the current base folder. I've only used a single dot '.\'

But only stating the file name should also work:

'KeyFile.txt'

If not, your current base folder is not the one you are assuming, or the file is not located at that place.

Re: Relative Path

varunreddy — Fri, 08 Jan 2016 18:39:47 GMT

Hi Swuehl,

Can you kndly explain this?

IF ISNULL(FileTime('$(vKeyFileLocation)')) = -1 THEN
CALL WriteMessageToLog('Expected Key File is not in the expected Location', '$(vKeyFileLocation)', 'KEY FILE');
LET keyFile_Load_Err = 1;
EXIT SCRIPT;
ENDIF

Re: Relative Path

swuehl — Sat, 09 Jan 2016 14:29:45 GMT

FileTime() will return NULL() if the given file does not exist (i.e. is not found in the specified location).

If the file is not found, call the sub routine WriteMessageToLog, set variable keyFile_Load_Err to 1 and exit script.

If the file is found, proceed with the script after ENDIF statement.

Re: Relative Path

varunreddy — Mon, 11 Jan 2016 15:35:01 GMT

Thank you Swuehl

Regards,

Varun