topic Re: Incremental Load issue in QlikView

Incremental Load issue

Tue, 09 Jun 2015 05:36:46 GMT

Hi Everyone,

I am getting error at the last line( Where Condition Load_Date>=$(VbuiMstr)),

Any suggestions would be greatly appreciated.

D_GIS_BUILDING_MSTR:
LOAD COMPANY_CODE,
OFFICE_CODE,
CITY_CODE,
OFFICE_NAME,
Date(Load_Date) as Load_Date ,
Load_DateTime
FROM
[..\Data Sources\Master\D_GIS_BUILDING_MSTR.qvd]
(qvd);

LET VbuiMstr=Peek('Load_Date',0,'D_GIS_BUILDING_MSTR');
//Let Vtodayt=Today()-1;

Incr_D_GIS_BUILDING_MSTR:
NoConcatenate
SQL SELECT *
FROM HRAnt.dbo."BUILDING_MSTR" where COMPANY_CODE='C002' and Load_Date>=$(VbuiMstr);

Thanks in Advance

Regards,

P.Divya

Re: Incremental Load issue

tresB — Tue, 09 Jun 2015 05:40:36 GMT

Try with single quotes around dollar expansion like:

Load_Date>='$(VbuiMstr)' ;

Re: Incremental Load issue

Tue, 09 Jun 2015 05:49:34 GMT

Hi tresesco,

Thanks for quick response,I tried with single quotes ,but still it is giving error

Re: Incremental Load issue

Tue, 09 Jun 2015 05:53:13 GMT

Hi ,

Please find below screenshot for your reference

Re: Incremental Load issue

jonathandienst — Tue, 09 Jun 2015 05:57:30 GMT

You should format the date field to match what your database expects in a date. And enclose in single quotes. Something like

LET VbuiMstr = Date(Peek('Load_Date',0,'D_GIS_BUILDING_MSTR'), 'DD-MM-YYYY');

(adjust the format string to your requirements)

Your screenshot is too small to be able to read the error message.

Re: Incremental Load issue

Tue, 09 Jun 2015 06:07:51 GMT

Hi ,

PFA

Re: Incremental Load issue

tresB — Tue, 09 Jun 2015 06:14:25 GMT

ODBC fail. Have you tried without this where clause, is that working?

Re: Incremental Load issue

jonathandienst — Tue, 09 Jun 2015 06:20:24 GMT

That looks like a login/permissions issue.

I suggest that you test the ODBC connection again. In the script editor, just create a new ODBC connection and click the test option (delete the newly created connection when done)

Re: Incremental Load issue

prashantbaste — Tue, 09 Jun 2015 06:35:28 GMT

Hi,

Please check with below code -

//-------------------------------------------------------------------------

D_GIS_BUILDING_MSTR:
LOAD COMPANY_CODE,
OFFICE_CODE,
CITY_CODE,
OFFICE_NAME,
Load_Date as Load_Date ,
Load_DateTime
FROM
[..\Data Sources\Master\D_GIS_BUILDING_MSTR.qvd]
(qvd);

LET VbuiMstr=Peek('Load_Date',0,'D_GIS_BUILDING_MSTR');
//Let Vtodayt=Today()-1;

Incr_D_GIS_BUILDING_MSTR:
NoConcatenate
SQL SELECT *
FROM HRAnt.dbo."BUILDING_MSTR" where COMPANY_CODE='C002' and Load_Date>=$(VbuiMstr);

//-------------------------------------------------------------------------

There is possibility of datatype mismatch in database field & value stored in variable. Better not to format field.

Please check & confirm if it resolves your query.

Regards,

Prashant P Baste

Re: Incremental Load issue

Tue, 09 Jun 2015 07:02:13 GMT

Hi tresesco,

Your information is also very helpful.Thanks for your Valuable information.

Regards,

P.Divya