Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

MK_QSL
Not applicable

Incremental Load

What is wrong in script from enclosed file?

When I load first script and create a QVD, it is giving me only 2013 until september end data.

But after doing incremental load, I got 2010, 2011,2012 data also.

11 Replies
ronaldocarrijo
Not applicable

Re: Incremental Load

His incremental load should be starting from 2013?

Data must not appear in previous years?

MK_QSL
Not applicable

Re: Incremental Load

Yes... I dont want data of Previous Years but when I do the Incremental Load, actually Script picking data from SQL server of previous years also.

What is the meaning of below error code?

ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: Incorrect syntax near '00'.

SQL SELECT *

FROM PPMSDB1.dbo."PMS_PURCHASE"

WHERE DECDDT  >= 30/09/2013 00:00:00 and  RIGHT(PNO,1) <> '4' and RIGHT(PNO,1) <> '3'

srchilukoori
Not applicable

Re: Incremental Load

Try using the Where condition, as shown in the image below, after the Load statement in the incremental load.

Where condition.png

MK_QSL
Not applicable

Re: Incremental Load

NO... it's not working...

FOR DECDDT i have done one change...

Date(FLOOR(DECDDT),'DD/MM/YYYY') as DECDDT

Not applicable

Re: Incremental Load

Hi Manish,

Try the attached app i hope it will solve ur problem.

Regards,

venkat

Not applicable

Re: Incremental Load

Try enclosing the date in single quotes and remove the time '30/09/2013'.

And make sure the date for comparison is in the proper format ('09/30/2013' instead of '30/09/2013')

Also for a more robust approach you can use the respective date's number Equivalents (where num(floor(DECDDT)) >= num('09/30/2013'))

ronaldocarrijo
Not applicable

Re: Incremental Load

Do this:

WHERE DECDDT> = '$ (vMaxDate)' and RIGHT (PNO, 1) <> '4 'and RIGHT (PNO, 1) <> '3'

MK_QSL
Not applicable

Re: Incremental Load

Dear Venkat,

It's working fine but again taking much time to find Max(DECDDT).

Overall time to add additional data to original QVD doesn't seems to be reduced.

Is there any other way to do the incremental load more fast?

MK_QSL
Not applicable

Re: Incremental Load

giving me this error.

ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: Conversion failed when converting date and/or time from character string.

SQL SELECT *

FROM PPMSDB1.dbo."PMS_PURCHASE"

WHERE DECDDT> = '$ (vMaxDate)' and RIGHT (PNO, 1) <> '4 'and RIGHT (PNO, 1) <> '3'