topic How to Write Script to Load Files with Timestamp Filenames in QlikView

How to Write Script to Load Files with Timestamp Filenames

ramcena306 — Wed, 25 Nov 2020 16:16:04 GMT

A folder contains multiple fields of the format 'CustmerDetails_YYYYMMDDHHMMSS.xlx'.

The YYYYMMDDHHMMSS part is the timestamp at which the file is generated. Files are generated in the folder every hour. Hence new files are constantly added in the folder, But with different Names.

How can i write the script to load all the files in the folder, into Qlikview application.

Re: How to Write Script to Load Files with Timestamp Filenames

Anil_Babu_Samineni — Wed, 25 Oct 2017 16:15:15 GMT

May be this?

Load * From CustomerDetails_*.xls;

Re: How to Write Script to Load Files with Timestamp Filenames

its_anandrjs — Wed, 25 Oct 2017 16:23:19 GMT

Try with attached file

Or you can try this as well as

LOAD

*,FileBaseName() as FileName

FROM

[CustmerDetails*.xlx]

(biff, no labels, table is [*$]);

Re: How to Write Script to Load Files with Timestamp Filenames

its_anandrjs — Wed, 25 Oct 2017 16:31:21 GMT

And another one also for loading all excel files.

LOAD *,FileBaseName() as FileName FROM

[CustmerDetails_*.xlsx]

(ooxml, embedded labels, table is [$(sheetName)]);

Re: How to Write Script to Load Files with Timestamp Filenames

MarcoWedel — Wed, 25 Oct 2017 20:09:01 GMT

Hi,

to extract the filename timestamp into a new field, you could add to your load something like:

Timestamp(Timestamp#(SubField(FileBaseName(),'_',-1),'YYYYMMDDhhmmss')) as FileTimestamp

hope this helps

regards

Marco