topic Re: Incremental Load in QlikView

Incremental Load

MK_QSL — Wed, 23 Oct 2013 13:40:27 GMT

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.

Re: Incremental Load

ronaldocarrijo — Wed, 23 Oct 2013 13:50:51 GMT

His incremental load should be starting from 2013?

Data must not appear in previous years?

Re: Incremental Load

MK_QSL — Wed, 23 Oct 2013 13:57:13 GMT

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'

Re: Incremental Load

srchilukoori — Wed, 23 Oct 2013 14:01:29 GMT

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

Re: Incremental Load

MK_QSL — Wed, 23 Oct 2013 14:08:27 GMT

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

FOR DECDDT i have done one change...

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

Re: Incremental Load

Wed, 23 Oct 2013 14:27:57 GMT

Hi Manish,

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

Regards,

venkat

Re: Incremental Load

Wed, 23 Oct 2013 14:37:48 GMT

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'))

Re: Incremental Load

ronaldocarrijo — Wed, 23 Oct 2013 14:48:21 GMT

Do this:

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

Re: Incremental Load

MK_QSL — Wed, 23 Oct 2013 14:53:58 GMT

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?

Re: Incremental Load

MK_QSL — Wed, 23 Oct 2013 15:03:41 GMT

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'

Re: Incremental Load

ronaldocarrijo — Wed, 23 Oct 2013 15:17:08 GMT

Do this, and tell me if it returns some data:

WHERE DECDDT >= '01-Jan-2013' and RIGHT (PNO, 1) <> '4' and RIGHT (PNO, 1) <> '3'

Re: Incremental Load

MK_QSL — Sat, 26 Oct 2013 11:43:51 GMT

any answer on this?