topic Exit Script in QlikView

Exit Script

Fri, 27 Apr 2012 07:53:06 GMT

I have loaded CSV files into QVW file. Now i have a requirement such that, in load script i have to write the script which will check that whether the files exist in the specified path or not. If not then it will exit the script without any error and if yes then it will transfer the CSV files to some other

How it can be done ??

Exit Script

Fri, 27 Apr 2012 08:04:50 GMT

Hi,

you could test file existence in your loading script as follows

if isnull(filetime('c:\qv\data\myfile.txt')) then

//do nothing

else

//file is actually there, load it

table_1:

LOAD col1,

col2

FROM

C:\QV\data\myfile.txt

(txt, codepage is 1252, embedded labels, delimiter is '\t', msq);

end if

Hope this helps

Hilaire

Re: Exit Script

Fri, 27 Apr 2012 08:28:38 GMT

hi,

try below code in edit script.

let vDataPath ='c:\Project\Data\Source\';
DIRECTORY $(vDataPath) ;

let vMoveDataPath ='c:\Project\Data\Destination\';
DIRECTORY $(vMoveDataPath) ;

Set NoOfFiles = 0;
For each file in filelist ('$(vDataPath)*.txt');
Let NoOfFiles = NoOfFiles + 1;
next
If(NoOfFiles=0) then
Set vNoOfFiles = 0;
ELSE
Set vNoOfFiles =1;
ENDIF

SWITCH $(vNoOfFiles)

CASE 1
vErrorType = ScriptError;
vErrorDetail = ScriptErrorList;
IF(ScriptErrorCount=0) then
execute cmd.exe /c move "$(vDataPath)*.csv" "$(vMoveDataPath)";
ENDIF

CASE 0
EXIT Script

ENDSWITCH

i hope this helps you.

Regards

Venkat

Exit Script

adhudson — Fri, 27 Apr 2012 09:06:24 GMT

Hi,

You can use the following script to match your requirement.

if FileSize('$(FileName)')>0 THEN

Load Statements

Else

Exit Script;

ENDIF

Regards

Andrew Hudson

Exit Script

Fri, 27 Apr 2012 10:14:58 GMT

Hi Hilaire,

Its working but now if mthe file is there then it should move to a specified path. How that will be done ??

Exit Script

Fri, 27 Apr 2012 12:09:54 GMT

to move the file to another directory, you can use the syntax shown in Venkat's post above

execute cmd.exe /c move c:\qv\data\myfile.txt c:\qv\data\old\myfile.txt

BTW, using his sample code or taking code samples from Rob Wunderlich's "qlikview cookbook" will make your code more robust if you don't know the file name beforehand

the "move c:\qv\data\myfile.txt c:\qv\data\old\myfile.txt" is actually a DOS command, you can use other dos commands as well (copy, del, ...)

Hilaire