topic Re: Assign Multiple values to variable in QlikView

Assign Multiple values to variable

Mon, 20 May 2013 03:43:19 GMT

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.

Re: Assign Multiple values to variable

kumarnatarajan — Mon, 20 May 2013 06:04:29 GMT

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

Re: Assign Multiple values to variable

Mon, 20 May 2013 08:07:59 GMT

Thanks Natrajan, it was of great help