topic Re: table not found: on partial reload in QlikView

table not found: on partial reload

Tue, 20 May 2014 14:46:49 GMT

Hi experts,

I have this below situation where when reloading works but on partial reload i get table not found error.

Please help me out resolve this.

Code:

PTable:

Load Name as pName,

Age as pAge,

City as pCity

From emp.qvd;

Test:

Add Load * inline

[Test,

1];

if isPartialReload()=-1 then

sPTable:

Load Name as pName,

Age as pAge,

City as pCity

From emp.qvd;

PTable:

Load pName,

pAge,

pCity

Resident sPTable

where not esits(pName);

Drop table sPTable;

end if

Re: table not found: on partial reload

its_anandrjs — Tue, 20 May 2014 14:53:36 GMT

Try with this some comma mistake

Code:

PTable:

Load Name as pName,

Age as pAge,

City as pCity

From emp.qvd;

Test:

Add Load * inline

[Test

1];

if isPartialReload()=-1 then

sPTable:

Load Name as pName,

Age as pAge,

City as pCity,

From emp.qvd;

PTable:

Load pName,

pAge,

pCity

Resident sPTable

where not esits(pName);

Drop table sPTable;

end if

Re: table not found: on partial reload

Tue, 20 May 2014 14:56:33 GMT

The error is for table PTable in the ispartialreload section... Test table works good.

Re: table not found: on partial reload

its_anandrjs — Tue, 20 May 2014 15:02:28 GMT

Update the query now check

Try with inplace of the below line of statement

where not esits(pName);

You can write

where not exists(pName);

Re: table not found: on partial reload

Tue, 20 May 2014 15:07:44 GMT

Sorry it was a typo... in the code there are no such mistakes....

Re: table not found: on partial reload

rbecher — Tue, 20 May 2014 15:08:31 GMT

Hi Pramod,

in partial reload any LOAD statement needs a preceeding REPLACE od ADD command. If not stated the LOAD will be ignored.

- Ralf

Re: table not found: on partial reload

Tue, 20 May 2014 15:17:49 GMT

Autoconcatenation add noconcatenate

sPTable:

noconcatenate

Load Name as pName,

Age as pAge,

City as pCity,

From emp.qvd;

Re: table not found: on partial reload

Tue, 20 May 2014 15:20:13 GMT

i have added the ADD in the partial realod section but still the issue exists...

Re: table not found: on partial reload

rbecher — Tue, 20 May 2014 15:22:56 GMT

I don't understand your code at all. Think about not using if isPartialReload(). Just add REPLACE/ADD to all LOAD statements and it will work in normal and partial loads.