topic Incremental Load in QlikView

Incremental Load

Wed, 10 Jun 2009 14:49:40 GMT

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Components.UserFiles/00.00.00.49.52/Cats.qvw]

Hi,

I am using rob's example of Incremental load and when I tried it with changes It is giving an error that the


Table not found Store MyDateTable in to Example123.qvd

can anybody help me?

Thanks in Advance

-Sravan

Incremental Load

Wed, 10 Jun 2009 14:52:17 GMT

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Components.UserFiles/00.00.00.49.52/Cats.qvw]

Incremental Load

Wed, 10 Jun 2009 15:25:04 GMT

Hi Sravan.

if you don't use the variable for the tablename in the statement it will work:

STORE

MyDataTable INTO $(QVDFILE);

regards,

Walter.

Incremental Load

Wed, 10 Jun 2009 15:41:35 GMT

Hello Walter,

thanks for the reply but it does not help..

Incremental Load

rwunderlich — Wed, 10 Jun 2009 22:39:22 GMT

Walter had you on the right track. You have mismatched case between the created table "MyDataTable" and datatable variable value "myDataTable". Correcting this makes the STORE work correctly. After that fix the incremental didn't work because you changed the Pkexp variable name to in some places but not all. You probably would have discovered that next. Here's an updated working copy.

-Rob

Incremental Load

Fri, 12 Jun 2009 15:42:26 GMT

Thanks Rob for your Help...