if isnull(QvdCreateTime('$(vQVDPath)$(vTableName).qvd')) then

[nilesh_gangurde]

Hii All,

let vQVDPath = ../Qvds/;

let vTableName = TABLENAME;

I am geting the Error because of "if isnull(QvdCreateTime('$(vQVDPath)$(vTableName).qvd')) then" is not working properly.

when i execute the script Qlikview is not identifying that Qvd is present or not.

if qvd is present then idealy it should go for "Else" but in my some of the Exractor its excecuting the "If" part only which is wrong.

guide how to tackel the same.

-Nilesh

[nilesh_gangurde]

Hii,

This is the Increamental load Script.

the above error is affecting the Increamental load of DATA.

-Nilesh

[kumarnatarajan]

Hi,

Put your variables in string format (single quotes is missing). Condition is right. See below mentioned syntex.

Ex:

LET vQVDPath='..\Data Sources\';

LET vTableName='Employee';

LET vTime=QvdCreateTime('$(vQVDPath)$(vTableName).qvd');


if isnull(QvdCreateTime('$(vQVDPath)$(vTableName).qvd'))  then


SET vTesrt=1;


ENDIF;

[nilesh_gangurde]

Yes,

but its woking properly for some Exractor without string format.

-Nilesh