resident function in qlikview

[#1]

Hi,

When i run the following code it throughs me an error saying

Table not found

STORE QLIKMART INTO '\\aa\bb\cc\QLIKMART.qvd' (qvd);

QLIKMART:

Load *

resident

from A_B;

left Join

Load  *Resident

from C;

LOAD *

resident

from D;

store QLIKMART into  '\\aa\bb\cc\QLIKMART.qvd' (qvd);

drop table QLIKMART;

Thanks,

Siri.

[alexpanjhc]

can you upload the qvw?

if you have this A_B and you add

qlikmart:

noconcatenate

load * resident A_B;

and comment the rest  and see if you get anything

[#3]

i tried and it did not throw me any error but i cannot see any new one in the datamodel

[alexpanjhc]

upload the qvw?

[MayilVahanan]

Hi

From table viewer, you can able to see whether A_B is available or not.. and also able to see what are the fields and how many rows contain, how they link with other table..

Try by giving full path once and tested it. Whether its store correctly or not

for example -> d:\aa\bb\cc\QLIKMART.qvd (qvd);

hope that helps..