load file from a folder

[#1]

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

[its_anandrjs]

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

LOAD

     *

FROM

(ooxml, no labels, table is Sheet1);

[maxgro]

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