Partial Reload Help!

[#1]

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

[marcus_sommer]

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

[annafuksa1]

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

[Anonymous]

I think you need to do this:

IF IsPartialReload() THEN

LEFT JOIN (DName)

NoteA:

REPLACE

load *

;

SQL SELECT NoteA

FROM TableA;

END IF;