Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
[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
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
[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Components.UserFiles/00.00.00.49.52/Cats.qvw]
Hi Sravan.
if you don't use the variable for the tablename in the statement it will work:
STORE
MyDataTable INTO $(QVDFILE);regards,
Walter.
Hello Walter,
thanks for the reply but it does not help..
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
Thanks Rob for your Help...