This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I'm trying to load data from files stored into a server shared directory, whose path is clearly differentent from user to user.
I'm actualy using this:
for each File in filelist('*.xlsx')
(ooxml, embedded labels, header is 1 lines, table is Contatti);
it works... ok
The problem is that one of my collegue has to change the directory to it's own path
to make it works.
Is there any set of instructions to set the path dinamicaly?
I tried with
Getfolderpath('DashBoard') as dropBox
thanks to all
I tried with this, but I didn't sorted out.
I got the solution mean time..
I used this
'C:\Users'&Mid(OSUser(),Index(OSUser(),'\'))&'.'&left(OSUser(),Index(OSUser(),'\')) as User
let vUser = peek('User',0);
drop table myUser;
it works, but now the myUser table is not really dropped and the load statement after defined loads data into this table
View solution in original post
let vDropBox = peek('dropBox',0);
drop table my_table;
DIRECTORY [$(vDropBox )\Contatti\Piani];
it return me
what can I do?
may you please show me what you wrote in your script?
Getfolderpath('Dropbox') as dropBox
drop table myTable;
I think the problem is on the Dropbox folder, with is on my local user profile.
QlikView search in \\server\user\v.dambruoso\Documents .... !!
Is there a function to get the system users to buid the path, or is there a way to choose from a list of path and reload the data after?
you got the same folder structure on your local machine and on the server
if yes then you can use relative paths
relative to the QVW file in which you have the script
suppose your folder structure is as follows:
Application (main folder)
DropBox (sub-folder) ->Contatti->Piani (2 sub folders)
suppose your file (qvw) is inside a sub-folder under QVW folder called myApp
then you can access the xml file as ..\..\DropBox\Contatti\Pianni\your_xml_file
hope this helps
can you show me in some way the folder structure of your application
may I can figure out
To get the user you could try it with: osuser() or getregistrystring().
"Cruscotto_Piani_Commerciale" is the dashboard I'm working on.
"Piani" is the folder I use to store xlsx files.
and both are on Dropbox folder