Store with variable

Tue, 16 Sep 2014 13:26:28 GMT

I have the following scritp which works, but I cannot seem te store the file with a variable filename. What am I doing wrong?

FOR EACH FoundFile IN FILELIST('\\..\*.log')
LET vFile = FileBaseName();

Temp:
LOAD
@1                                                             as FileDate,
@2                                                             as CommandTime,
@4                                                             as Command,
RowNo()                                                        as Row,
subfield(FileName(), '.',1)                       as File

FROM [$(FoundFile)] (txt, unicode, no labels, delimiter is ' ', msq, filters(
Remove(Row, RowCnd(CellValue, 8, StrCnd(contain, 'Execution', not))),
Remove(Col, Pos(Top, 7)),
Remove(Col, Pos(Top, 6)),
Remove(Col, Pos(Top, 5)),
Remove(Col, Pos(Top, 4)),
Remove(Col, Pos(Top, 3))
));

Left join
LOAD
max(Row) as MaxRows,
File
Resident Temp Group by File;

[$(vFile)]:
NoConcatenate
LOAD
if(MaxRows=1, (Now()-CommandTime)) as CurrentReloadTime,
File
Resident Temp;

Store [$(vFile)] into \\..\LOG $(vFile).qvd (qvd);

Drop Table Temp;
Drop Table [$(vFile)];

next FoundFile

Re: Store with variable

Anonymous — Tue, 16 Sep 2014 13:44:26 GMT

i do it with 2 variables and it works fine

store $(vAppName) into $(vQVDName)$(vFileExt)

;

topic Store with variable in QlikView

Store with variable

Re: Store with variable