Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
charliea
Contributor
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

0 Replies