Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

jonasheisterkam
Contributor III

Check if relative, absolute and network path are the same

Hi,

is it possible to chek if this paths refers the same path?

How can I get the set directory to convert the relative path?

Thanks,

Jonas

3 Replies

Re: Check if relative, absolute and network path are the same

Jonas

Have you looked at the FileDir()  and FilePath() commands ?

Example below, you'll need to change it to point to your qvd file,

TestTable :

LOAD

  ID,

  FileDir() as Dir ,

  FilePath() as Path

FROM

[..\..\Bill\Qlikview\QVDTable.qvd]

(qvd);

Best Regards,    Bill

jonasheisterkam
Contributor III

Re: Check if relative, absolute and network path are the same

Thanks Bill,

but I must need to know the path also if there is no file and if directory is used in the script.

I wrote a sub with a extended qvd store routine. In the sub is a security option with field black and white list and filter options for each user. There is a user table where every user has a path which can be every type of folder address. Because I set ntfs rights to the exported qvd and filter it i must look that not two different written paths refers the same file. Because of the security issues I only export if all user who referred an export are allowed to see the same data. 

Re: Check if relative, absolute and network path are the same

Jonas

Not quite as simple as first impressions....  you may well need to breakout to something like PowerShell and use something like Resolve-Path, unless someone else can suggest a pure QlikView approach,

Best Regards,     Bill

Community Browser