topic Re: Error in Script in QlikView

Error in Script

upaliwije — Sun, 23 Feb 2014 10:09:12 GMT

sales:

LOAD [POLICY_NO],

CLA_CODE ,

PRD_CODE ,

if (CLA_CODE='MC','MOTOR',if(CLA_CODE='M3','MOTOR',if(CLA_CODE='M4','MOTOR','NON_MOTOR')))as MONM,

POL_PERIOD_FROM,

POL_PERIOD_TO,

POL_SUM_INSURED,

ME_CODE,

BCOD,

TRN_TYPE,

POL_TYPE,

//if (POL_TYPE='N', 'NEW',if(POL_TYPE='R','REN',if(POL_TYPE='A','ADD',if(POL_TYPE='F','REF'))))as BUS_TYPE,

if (POL_TYPE='N', 1,if(POL_TYPE='R',1,if(POL_TYPE='F'and POL_STATUS='9',-1)))as Nos,

REF_NO,

RC_TRN_TYPE,

T_DATE , //tranaction date

TRN_DATE AS RISK_DATE,

PREMIUM,

CC_CODE

FROM

E:\Qlikview\QVD\FACT_Table\Sales.qvd

(qvd)

WHERE year( T_DATE)>=2011 and BCOD='KU00' ;

Inner Join

Claims:

LOAD [POLICY_NO],

CLAIM_NO,

BCOD,

CRE_ACC_PAID_BRANCH,

PAID_DATE ,

ME_CODE,

LOSS_DATE,

CRE_PAID_AMOUNT ,

CRE_CEN_PRS_NAME,

CRE_CAUSE_LOSS,

CLA_CODE,

if (CLA_CODE='MC','MOTOR',if(CLA_CODE='M3','MOTOR',if(CLA_CODE='M4','MOTOR','NON_MOTOR')))as MONM,

PRD_CODE

FROM

[..\QVD\FACT_Table\Claims.qvd]

(qvd) where BCOD='KU00' ;

FACT:

NoConcatenate

LOAD * Resident sales

where LOSS_DATE >=[POL_PERIOD_FROM] and LOSS_DATE <=[POL_PERIOD_TO];

DROP TABLE sales;

Concatenate

LOAD [POLICY_NO], PREMIUM

from

E:\Qlikview\QVD\FACT_Table\Sales.qvd

where not Exists([POLICY_NO]);

Dear Friends

When run the above script in my data model I get the error message as given in the attachment. Pls let me know where I have made the mistake in my script.

Re: Error in Script

sundarakumar — Sun, 23 Feb 2014 10:26:15 GMT

Try moving

Drop table sales;

to the end of the script.

-Sundar

Re: Error in Script

maxgro — Sun, 23 Feb 2014 10:34:25 GMT

you have to add

(qvd)

to the last file you read as you did for other qvd files in your script

Concatenate

LOAD [POLICY_NO], PREMIUM

from

E:\Qlikview\QVD\FACT_Table\Sales.qvd (qvd)

where not Exists([POLICY_NO]);

Re: Error in Script

Sun, 23 Feb 2014 10:35:26 GMT

can u upload dummy data sample

Re: Error in Script

Sun, 23 Feb 2014 10:45:42 GMT

FACT:

NoConcatenate

LOAD * Resident sales

where LOSS_DATE >=[POL_PERIOD_FROM] and LOSS_DATE <=[POL_PERIOD_TO];

DROP TABLE sales;

Concatenate

LOAD [POLICY_NO], PREMIUM

from

E:\Qlikview\QVD\FACT_Table\Sales.qvd(qvd)

where not Exists([POLICY_NO]);

Re: Error in Script

upaliwije — Sun, 23 Feb 2014 10:47:02 GMT

Thanks

It is working

Re: Error in Script

marchoctober — Sun, 23 Feb 2014 10:53:44 GMT

Usually, 90% of script errors are related to syntax, mostly missed ; somewhere, recently other syntax issues.