topic Re: FileList can't solve variable correctly in QlikView

FileList can't solve variable correctly

Wed, 09 Aug 2017 14:46:22 GMT

Hi All,

this code works:

For each File in FileList('C:\T\*.xlsx');

LOAD Field

FROM

[$(File)]

(ooxml, embedded labels, table is Sheet1);

next File;

this code gives me an error:

SET Tpath = 'C:\T\*.xlsx';

For each File in FileList($(Tpath));

LOAD Field

FROM

[$(File)]

(ooxml, embedded labels, table is Sheet1);

next File;

any suggestion?

thanks!

sunny_talwar — Wed, 09 Aug 2017 15:51:20 GMT

May be use directory loop instead of filelist to do this

Also, look at example number 2 here:

kaushiknsolanki — Wed, 09 Aug 2017 15:51:25 GMT

Hi,

Try this.

For each File in FileList('$(Tpath)');

LOAD Field

FROM

[$(File)]

(ooxml, embedded labels, table is Sheet1);

next File;

Regards,

Kaushik Solanki

joydipp1988 — Wed, 09 Aug 2017 16:02:32 GMT

I believe the code posted by Kaushik can solve your problem. You need to provide the variable inside single inverted i.e. FileList('$(Tpath)').

So if your problem is solved, please marked the answer as "Correct Answer".

Thnaks,

Joy

Wed, 09 Aug 2017 16:13:27 GMT

Thank you!