topic Re: Help in Loading files in QlikView

Help in Loading files

Sat, 09 May 2015 04:38:41 GMT

Hi All,

I have a variable which contains the file name as 'MM YYYY ABC Test_xyz.xls'.

The actual file name is 01 2015 ABC Test_xyz.xls.

There is a folder which contains many files with different filenames.

I have to load only those files from a folder whose file name matches with the pattern 'MM YYYY ABC Test_xyz.xls'.

MM YYYY may change depending on the year and month values.

Can someone please help me?

Thanks,

Asma

Sat, 09 May 2015 05:22:35 GMT

Use wildcard in the place of MM YYYY .

You can try like this:

Table1:
LOAD Field1,
Field2
FROM
[Travel pjt\?? ???? ABC Test_xyz.xlsx]
(ooxml, embedded labels, table is Sheet1);

robert_mika — Sat, 09 May 2015 05:43:50 GMT

Try

FOR Each File in filelist ('Files\*ABC Test_xyz.xlsx')

LOAD A,B

FROM

'$(File)'

(ooxml, embedded labels, table is Sheet1);

NEXT File;

Sat, 09 May 2015 09:56:49 GMT

Thanks for the reply

But using * didn't work.

robert_mika — Sat, 09 May 2015 10:39:58 GMT

Are you getting any errors?

Is the difference in pattern always MM YYYY?

maxgro — Sat, 09 May 2015 11:55:42 GMT

LOAD

FROM

[?? ???? ABC*.xlsx]

(ooxml, embedded labels, table is Sheet1);