For each File - Syntax Error

haymarketpaul — Wed, 25 Nov 2020 16:16:04 GMT

QV12 SR4

The following code worked great for at least a year until i had my computer reimaged (win10 reinstall) and i had to reinstall Qlikview. Now i get a syntax error that i can't fathom out.

The error occurs immediately after the line in red below. There is a file called dbCIPS - All - Apr 9 2018 09-47-14 AM.CSV in the vSPOPAdPromo folder.

Any ideas most welcome.

The syntax Error...

Unexpected token: '\\HAMMSTORE\Direct\Circulation\Data', expected one of: '(', ',', ':', 'OPERATOR_PLUS', 'OPERATOR_MINUS', 'OPERATOR_MULTIPLICATION', 'OPERATOR_DIVISION', ...

FOR each File in filelist >>>>>>\\HAMMSTORE\Direct\Circulation\Data<<<<<< ops\CIPS\Silverpop Database\dbCIPS - All*.CSV

The code...

//Path to AdPromo Files

LET vSPOPAdPromo = '\\' & '$(vHammstore)' & '\Direct\Circulation\Data ops\CIPS\Silverpop Database\';

FOR each File in filelist $(vSPOPAdPromo)dbCIPS - All*.CSV

Folder:

LOAD

'$(File)' as Name,

FileTime( '$(File)' ) as FileTime

autogenerate 1;

NEXT File

LatestAdPromoFile:

First 1

LOAD

Name,

SubField(Name,'\',SubStringCount(Name,'\')+1) as FileNameOnly,

FileTime,

1 as dummy

Resident Folder

Order By FileTime DESC;

DROP Table Folder;

LET vLatestAdPromoFile = Peek('FileNameOnly',0,'LatestAdPromoFile');

LET vLatestAdPromoFileWithPath = Peek('Name',0,'LatestAdPromoFile');

DROP Table LatestAdPromoFile;

Re: For each File - Syntax Error

swarnendu — Mon, 09 Apr 2018 09:00:02 GMT

change the folder Path and reload it.

Hope so its will be work . i am also facing same issue in some month ago .

Re: For each File - Syntax Error

haymarketpaul — Mon, 09 Apr 2018 09:09:54 GMT

No luck - same message i'm afraid

Re: For each File - Syntax Error

sasiparupudi1 — Mon, 09 Apr 2018 09:16:58 GMT

May be try like this

FOR each File in filelist ('$(vSPOPAdPromo)*.CSV')

Folder:

LOAD

'$(File)' as Name,

FileTime( '$(File)' ) as FileTime

autogenerate 1;

NEXT File

Re: For each File - Syntax Error

haymarketpaul — Mon, 09 Apr 2018 09:22:24 GMT

Wonderful - thank you - works perfectly

topic Re: For each File - Syntax Error in QlikView

For each File - Syntax Error

Re: For each File - Syntax Error

Re: For each File - Syntax Error

Re: For each File - Syntax Error

Re: For each File - Syntax Error