My path is a folder on our joint server, looking like this:
It is a valid path when I use other ways of reaching it.. :/
I've also tried this, however it does not seem to work neither,
It cannot find any files, so the number of rows loaded is 0...
Could it be a firewall issue or something?
'' AS SourceFile
for each FileExtension in 'qvw'
for each FoundFile in filelist( Root & '\*.' & FileExtension)
LOAD '$(FoundFile)' as SourceFile
Set vConcatenate = Concatenate;
for each SubDirectory in dirlist( Root & '\*' )
Call ScanFolder('\\FS06\Users6\A63434\Skrivbord\Mål och Mina Listor\Qlick Analys\LOR uppföljning\XXX') ;
I think you should try to load a single file from this folder with the table-wizard. Then you will get the correct syntax for the fields and the file-format and of course you will see if you could access this folder and the files there. If this worked you could wrap the loop-logic around it.
I've actually tried this before posting on the forum, unfortunately!
Connecting with the wizard renders the following "lib link" [lib://LOR/LOR 201601.xls]
I've tried using the 'lib://LOR as "root" and then changed the "\" to a "/" since the wizard wants it to be "/"?
Rendering the following:
Root = 'lib://LOR'
for each FoundFile in filelist( Root & '\*.xls')
FROM $file (xls, unicode, no labels, delimiter is '\t', msq, header is 10 lines);
This "should" work then right?