Hi,
I am trying to load all files from a directory and differentiate them with the file name.
I tried the script below but Qlik Sense load nothing as if there is no script at all. I don't understand why.
for each File in filelist('C:\Users\NG6A463\Desktop\Test\test*.xlsx')
LOAD
*,
filename() as FileName
from $(File)
(ooxml , embedded labels , table is Sheet1);
next File
In my directory I've got 3 files:
test-1.xlsx
test-2.xlsx
test-3.xlsx
Thanks for your help.
Charlie