Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.
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