Discussion board where members can get started with Qlik Sense.
I need to load all file name in a Path that I have set like a variable.
I try to use this code, but it doesn't fix:
SET vPath = 'lib://FilePath/';
filebasename( ) as x
(biff, embedded labels, table is Sheet1$);
Where Lib is the connection name.
Go to Solution.
in this folder, you have many excel files for example, and you want to import the full name of each file?
Try as follow: (adapt it tu ur script)
load 0 as field AutoGenerate(0);
For Each vPath in FileList('lib://Test/*.xlsx')
'$(vPath)' as name
(ooxml, embedded labels, table is Sheet1);
Drop Field field From Data;