Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Incremental Load

[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

Tags (1)
1 Solution

Accepted Solutions

Incremental Load

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

5 Replies
Not applicable

Incremental Load

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

Not applicable

Incremental Load

Hi Sravan.

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

STORE

MyDataTable INTO $(QVDFILE);

regards,

Walter.

Not applicable

Incremental Load

Hello Walter,


thanks for the reply but it does not help..

Incremental Load

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

Not applicable

Incremental Load

Thanks Rob for your Help...

Community Browser