topic Re: Partial Reload Help! in QlikView

Partial Reload Help!

Wed, 11 Jan 2017 20:42:07 GMT

Hello All,

I'm having an issue with Partial Load or it may be just my lack of understanding. I am trying to join a table from another database with this NoteA table which contains an inputfield. When I run a partial reload in this scenario I get the same dataset (looking in the CTRL+T table preview) even if I edit some data on the back end SQL tables, I've tested around and even used replace but still no new data. How can I get the new data loaded into my file without refreshing wholly which would take an extended period of time? Thanks!

IF IsPartialReload() THEN

DROP TABLE NoteA;

END IF;

NoteA:

LEFT JOIN (DName)

ADD SQL

SELECT NoteA

FROM TableA

Re: Partial Reload Help!

marcus_sommer — Thu, 12 Jan 2017 12:08:22 GMT

I'm not absolutely sure but I think you need to include the load of the table DName within the partial load to be able to perform the join.

- Marcus

Re: Partial Reload Help!

annafuksa1 — Thu, 12 Jan 2017 12:45:29 GMT

my first thought will be export data from SQL and Create QVD and work with this as working on SQL Script in QLikview in confusing and you should not to mix them .

Good idea is to add your app to post as its easier to help if we can see all contest

Anna

Re: Partial Reload Help!

Anonymous — Thu, 19 Jan 2017 22:30:20 GMT

I think you need to do this:

IF IsPartialReload() THEN

LEFT JOIN (DName)

NoteA:

REPLACE

load *

;

SQL SELECT NoteA

FROM TableA;

END IF;