Incremental Load

[#1]

[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

[#2]

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

[#3]

Hi Sravan.

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

STORE

MyDataTable INTO $(QVDFILE);

regards,

Walter.

[#4]

Hello Walter,

thanks for the reply but it does not help..

[rwunderlich · Accepted solution]

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

[#6]

Thanks Rob for your Help...