table not found: on partial reload

[#1]

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

[its_anandrjs]

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

[#3]

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

[its_anandrjs]

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);

[#5]

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

[rbecher]

Hi Pramod,

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

- Ralf

[#7 · Accepted solution]

Autoconcatenation add noconcatenate

     sPTable:

     noconcatenate

     Load Name as pName,   

     Age as pAge,

     City as pCity,

     From emp.qvd;

[#8]

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

[rbecher]

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.