Discussion Board for collaboration on QlikView Scripting.
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.
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 *
WHERE DECDDT >= 30/09/2013 00:00:00 and RIGHT(PNO,1) <> '4' and RIGHT(PNO,1) <> '3'
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'))
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?
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 *
WHERE DECDDT> = '$ (vMaxDate)' and RIGHT (PNO, 1) <> '4 'and RIGHT (PNO, 1) <> '3'