topic Re: For...Next Loop through folder error in QlikView

For...Next Loop through folder error

prees959 — Tue, 16 Oct 2018 10:09:17 GMT

Hi,

I'm using the following script to convert a load of CSV files to QVD

for each file in FileList('$(vFolder)datafile*.csv')

Daily:

LOAD *

FROM $(file)

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

Let vPathFileDate = Date(Date#(left(subfield(subfield('$(file)','\', -1), '_', -1), 8), 'YYYYMMDD'), 'YYYY_MM_DD');

STORE Daily INTO ..\..\Daily\Daily_$(vPathFileDate).QVD;

DROP TABLE Daily;

Next file;

It is running fine until it gets tot the end and I get a

Script line error:

Next File

Can anyone help....?

Thanks,

Phil

Re: For...Next Loop through folder error

m_woolf — Tue, 16 Oct 2018 11:49:48 GMT

Try removing the semicolon after next file

Re: For...Next Loop through folder error

prieper — Tue, 16 Oct 2018 12:56:46 GMT

Do not think that the semicolon makes the difference.

Would rather check the spelling and/or rename the variable to vFile or the like

Re: For...Next Loop through folder error

nsetty — Tue, 16 Oct 2018 13:42:24 GMT

Try

Let vPathFileDate = Date#(Date#(left(subfield(subfield('$(file)','\', -1), '_', -1), 8), 'YYYYMMDD'), 'YYYY_MM_DD');

Re: For...Next Loop through folder error

Peter_Cammaert — Tue, 16 Oct 2018 14:08:28 GMT

It runs just fine for me and I made no changes. You may have different values in your variables and/or different folder permissions.

IMHO this is an ideal case to use the QlikView Script Debugger. After each statement, it lets you check all variables vlaues before you use them (e.g. vFolder, file, and especially vPathFileDate)