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]

if you use resident, you do not want to use from to confuse qlikview.

eliminate the from in your scripts.

[#3]

sorry

i removed from and throughed the same error

[#4]

QLIKMART:

Load * resident A_B;

left Join

Load  *Resident C;

LOAD *

resident D;

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

drop table QLIKMART;

[alexpanjhc]

after left join,

you have load *resident, i think you need a space in bewteen * and resident

what is your purose for

LOAD *

resident

D;?

you want to concatnate to QLIKMART table?

can you try to comment on the part and see if you can get something? in your table viewer, do you see anything at all?

[#6]

i tried with space and yes i want to concatenate to QLIKMART. i tried 

QLIKMART:

Load * resident A_B;

but i cannot see anything in the datamodel

and i tried

QLIKMART:

Load  * resident A_B;

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

drop table QLIKMART;

which throws me again the same error

[alexpanjhc]

is A_B a table you created earlier?and that table was not dropped?

[#8]

yes it was created earlier and it was not dropped

[alexpanjhc]

can you see this table in table viewer?

[#10]

yes i can see A_B table in the datamodel