Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
MK_QSL
MVP
MVP

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
Partner
Partner

His incremental load should be starting from 2013?

Data must not appear in previous years?

MK_QSL
MVP
MVP
Author

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
Specialist
Specialist

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

Where condition.png

MK_QSL
MVP
MVP
Author

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

FOR DECDDT i have done one change...

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

Not applicable

Hi Manish,

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

Regards,

venkat

Not applicable

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
Partner
Partner

Do this:

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

MK_QSL
MVP
MVP
Author

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
MVP
MVP
Author

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'