Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 joinLOADmax(Row) as MaxRows,FileResident Temp Group by File;[$(vFile)]:NoConcatenateLOADif(MaxRows=1, (Now()-CommandTime)) as CurrentReloadTime,FileResident Temp;Store [$(vFile)] into \\..\LOG $(vFile).qvd (qvd);
Drop Table Temp;Drop Table [$(vFile)]; next FoundFile
i do it with 2 variables and it works fine
store $(vAppName) into $(vQVDName)$(vFileExt)
;