topic Re: Error Load Script in QlikView

Error Load Script

ecabanas — Wed, 01 Apr 2015 15:09:43 GMT

I have this script and give an error, did you know why?

LET vExecTime=UTC();

Set vLastExecTime=0;

if (not IsNull(QvdCreateTime('$(VStore)INVENTTRANS_INCREMENTAL.qvd'))

LoadTime:

Load Max(LastModifiedDate)as LastModifiedDate

From $(VStore)INVENTTRANS_INCREMENTAL.qvd(qvd);

Let vLastExecTime=peek('LastModifiedDate',0,'LoadTime');

Drop Table LoadTime;

);

Many thank's

Re: Error Load Script

ramoncova06 — Wed, 01 Apr 2015 15:12:52 GMT

use an if ... then instead of if ()

If..then..elseif..else..end if

The if..then control statement is a script selection construct forcing the script execution to follow different paths depending on one or several logical conditions. The syntax is:

if condition then

[ statements ]

{ elseif condition then

[ statements ] }

[ else

[ statements ] ]

end if

Where:

condition is a logical expression which can be evaluated as true or false.

statements is any group of one or more QlikView script statements.

Since the if..then statement is a control statement and as such is ended with either a semicolon or end-of-line, each of its four possible clauses (if..then, elseif..then, else and end if) must not cross a line boundary.

Examples:

if a=1 then

load * from abc.csv;

sql select e, f, g from tab1;

end if

if a=1 then; drop table xyz; end if;

if x>0 then

load * from pos.csv;

elseif x<0 then

load * from neg.csv;

else

load * from zero.txt;

end if

Re: Error Load Script

ecabanas — Wed, 01 Apr 2015 15:19:55 GMT

Hi Ramon,

Many thank's but still with problems 😞

see the picture

Eduard

Re: Error Load Script

rubenmarin — Wed, 01 Apr 2015 15:23:39 GMT

Hi Eduard, following Ramon instructions:

Since the if..then statement is a control statement and as such is ended with either a semicolon or end-of-line, each of its four possible clauses (if..then, elseif..then, else and end if) must not cross a line boundary.

Re: Error Load Script

ramoncova06 — Wed, 01 Apr 2015 15:29:23 GMT

yes the "if" and "then" have to be in the same line

Re: Error Load Script

ecabanas — Wed, 01 Apr 2015 15:29:59 GMT

Hi Ruben, But i did not understand 😞

Re: Error Load Script

ecabanas — Wed, 01 Apr 2015 15:30:56 GMT

Many many thank's Ramon!!!!