Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

charliea
New Contributor

Load all files from a directory and differentiate them

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