topic Re: load file from a folder in QlikView

load file from a folder

Fri, 02 May 2014 20:37:52 GMT

Hi,

I have an ftp data landing folder where new data comes daily. Sometimes, the file names are not consistent. What I want to do is load whatever file name is in the directory and delete it after reload

Can someone please guide me how can I dynamically load file from a directory if I don't know the name. I want to load whatever file is there.

If by any chance get two files, Is it possible to only reload the one with latest creation date?

Arif

Re: load file from a folder

its_anandrjs — Fri, 02 May 2014 21:13:19 GMT

Use for loop or you can load like below script if all files are *.xlsx files

LOAD

FROM

(ooxml, no labels, table is Sheet1);

Re: load file from a folder

maxgro — Sat, 03 May 2014 07:54:45 GMT

1) read files in a folder

- as Anand suggested or

- looping on files of a folder

http://community.qlik.com/message/498386#498386

2) get last modified time of a file

- filetime function

Returns a timestamp for the date and time of the last modification of the file filename. If no filename is specified, the function will refer to the currently read table file.

3) delete files

example of execute command

http://community.qlik.com/message/337651#337651