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
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