Check if relative, absolute and network path are the same

[jonasheisterkam]

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

[Anonymous]

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]

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. 

[Anonymous]

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