Discussion board where members can get started with Qlik Sense.
Hello! So I want to get all the files from a directory in Qlik Sense Desktop.
Found a nice post on the forum
Set vConcatenate = ;
'' 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('C:\Users\Public\Pictures\Sample Pictures\') ;
But It's not working. The FoundFile variable is always null. I've tried with different methods and I get Null every time.
There is another example on this page Attribute ‒ Qlik Sense
But those are not working either.
What is wrong?
Any idea of why it's not working without a connection?
I just tried the same code with the location hard coded and it worked.
call DoDir ('D:\Dev\External Data')
//call DoDir ('lib://External_Data')
The suggestion was to think at the regular expressions approach...
The script doesn't contain any detail or useful info in that case and trying it out doesn't require the source files.
In this specific case, in order to use the regular expressions there's a macro in the document...that obviously you can't use in Sense.
Anyway, if you found a solution that solves your issue...go that way.