Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator
Creator

How to load from source file with similar file name

Hi I remember I learnt this in training but could not find it in the training book. If I have two source file 2018MasterList.xlsx and 2019MasterList.xlsx. How to write script to load them both use maybe *MasterList.xlsx or something similar that I can't exactly remember. Thanks.

5 Replies
MVP & Luminary
MVP & Luminary

Just like you thought. Change the filename to use * for a wildcard

*MasterList.xlsx

-Rob

Creator
Creator

I got Bad Zip file error but the error is gone if I use 2018MasterList.xlsx or 2019MasterList.xlsx so both files are not corrupted.

MVP & Luminary
MVP & Luminary

Can you post your script log?

-Rob

Creator
Creator

LOAD
[Health Status],
[Month Reporting On] as [Month Full Name],
Modified,
[Modified By]

FROM
[http://XXXXX/*MasterList.xlsx]
(
ooxml, embedded labels, table is Sheet1)
Where [Month Reporting On]<>'February';

MVP & Luminary
MVP & Luminary

You are trying to load these with http:, not directly from file?  I don't think wildcard will work with http:. Instead you will have to list the contents of the directory and write a loop to process each file.  I believe there are working examples here on the forum, but I can't locate one at the moment. 

Perhaps someone else can point to an example?

-Rob