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

Check if relative, absolute and network path are the same

jonasheisterkam — Fri, 22 Nov 2013 20:54:03 GMT

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

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

Anonymous — Sat, 23 Nov 2013 18:05:07 GMT

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

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

jonasheisterkam — Sat, 23 Nov 2013 18:57:13 GMT

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

Anonymous — Sat, 23 Nov 2013 19:12:10 GMT

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