Load multiple fine in qilik

[qliklearnervir]

We having a 5 files generated daily in a folder:-

ET<YYMMDD>

AT<YYMMDD>

GT<YYMMDD>

KT<YYMMDD>

MT<YYMMDD>

Here we need to load all these files in a one shot instead of writing multiple load statement.

And in another situation we need to check that file is available in the folder or not as not necessary that all these files should available daily.

LOAD *

FROM

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

[vinieme12]

as below

LOAD *

FROM

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

if you want to load files for a particular date then create a variable to use

example:

let vDate = DATE(Today(),'YYMMDD');

LOAD *

FROM

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);