Assign Multiple values to variable

[#1]

Dear QLikview Experts,

I have to load data from multiple files which have timestamp at the end of their names

Presently we are using

SET vActualFileLoc = "Actual_MAINFILE*.csv'";

Files are like

ACTUAL_MAINFILE_201101*.csv'";

ACTUAL_MAINFILE_201102*.csv'";

and so forth till current month.

I am loading it as

For

each vActualBW in filelist($(vActualFileLoc))

LOAD *FROM

$(vActualBW)

(txt, utf8, embedded labels, delimiter is '|');

Next

I need to change this so that I start the loading from 201206 month. I tried and found that CONCAT function could be of help here. But when I tried, it was not working.

Pls guide here.

[kumarnatarajan · Accepted solution]

Hi,

Try this one.

For each vActualBW in filelist($(vActualFileLoc))

if left(SubField($(vActualBW),'_',3),6)>=201106 then

LOAD *FROM
$(vActualBW)
(txt, utf8, embedded labels, delimiter is '|');

ENDIF

Next

[#3]

Thanks Natrajan, it was of great help