Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

load file excel

Hello,
I would like to know the best solution to load excel files every month at once, each file contains the same fields, just the values ​​that change each month.
Thank you for your help.
Best regards

Maurice


1 Reply
MVP & Luminary
MVP & Luminary

You can load all the excel files using a * as wildcard:

MyData:

LOAD * FROM [D:\ExcelFiles\*.xlsx] (ooxml, embedded label, table is Sheet1);

Or you can use a loop: loop through to load all files from a folder and its subfolders?


talk is cheap, supply exceeds demand