topic Re: How to load from source file with similar file name in QlikView

How to load from source file with similar file name

posywang — Mon, 11 Mar 2019 20:19:54 GMT

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.

Re: How to load from source file with similar file name

rwunderlich — Mon, 11 Mar 2019 20:25:53 GMT

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

*MasterList.xlsx

-Rob

Re: How to load from source file with similar file name

posywang — Mon, 11 Mar 2019 20:36:33 GMT

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.

Re: How to load from source file with similar file name

rwunderlich — Mon, 11 Mar 2019 21:49:24 GMT

Can you post your script log?

-Rob

Re: How to load from source file with similar file name

posywang — Tue, 12 Mar 2019 14:31:25 GMT

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

Re: How to load from source file with similar file name

rwunderlich — Tue, 12 Mar 2019 16:31:30 GMT

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