topic Re: Preceding load error in Incremental load in QlikView

Preceding load error in Incremental load

Sun, 11 Oct 2015 07:06:18 GMT

Hi,Qlikers

for incremental load

after reading the data from qvd Created one variable and storing the max date in that variable

like vMax=peek('Date',-1,Temp);

and after that i connected to sql server and written presceding load some thing like

Incremental:

LOAD *,Date(Floor( TimeData)) as Date;

SQL SELECT *

FROM Emp

Where Date>=$(vMax);

but it is giving error message

ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: Invalid column name 'Date'.

SQL SELECT *

FROM Emp

Where Date>=9/12/2015

could any one have idea about this

please help me

thanks in advanse

regards,

hemesh

Re: Preceding load error in Incremental load

MK_QSL — Sun, 11 Oct 2015 07:12:03 GMT

vMax=peek('Date',-1,'Temp'); // You missed single quotes for Temp

Incremental:

LOAD *,Date(Floor( TimeData)) as Date;

SQL SELECT *

FROM Emp

Where Date>='$(vMax)'; // $(vMax) should be '$(vMax)'

Re: Preceding load error in Incremental load

Sun, 11 Oct 2015 07:21:31 GMT

still it is showing

ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: Invalid column name 'Date'.

SQL SELECT *

FROM Emp

Where Date>='9/12/2015'

By the time of executing the records are same in qvd and

Incremental:

LOAD *,Date(Floor( TimeData)) as Date;

SQL SELECT *

FROM Emp

Where Date>=$(vMax);

is this because of that

Re: Preceding load error in Incremental load

MK_QSL — Sun, 11 Oct 2015 07:25:01 GMT

Try

Where TimeData >= '$(vMax)';

Re: Preceding load error in Incremental load

stevedark — Sun, 11 Oct 2015 07:41:38 GMT

This is telling you that the field Date does not exist in the table Emp.

Go back to your table in SQL Management Console and check the fields. Given your load statement I think MRKachhiaIMP‌ is probably correct.

Whatever goes into your SQL statement must execute correctly when copied and pasted into management studio.

For that reason, you probably need to format your vMax variable accordingly also, depending on the setup of your SQL Server, perhaps:

vMax= Date(peek('Date',-1,'Temp'), 'YYYY-MM-DD hh:mm:ss.fff');

Another point of note, using Peek -1 you need to be 100% confident that the date on the last row is the one you need to load from. If you are enforcing this with an ORDER BY in the QVD load you will be causing it to be non-optimised and it will therefore be slow anyway - kind of removing the point of an incremental load.

This post has more on incremental loads:

http://www.quickintelligence.co.uk/qlikview-incremental-load/

Steve

Re: Preceding load error in Incremental load

Sun, 11 Oct 2015 07:42:04 GMT

Now i am getting thank you manish