topic Re: resident function in qlikview in QlikView

resident function in qlikview

Tue, 02 Oct 2012 21:02:01 GMT

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.

Re: resident function in qlikview

alexpanjhc — Tue, 02 Oct 2012 21:09:36 GMT

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

eliminate the from in your scripts.

Re: resident function in qlikview

Tue, 02 Oct 2012 21:10:40 GMT

sorry

i removed from and throughed the same error

Re: resident function in qlikview

Tue, 02 Oct 2012 21:12:01 GMT

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;

Re: resident function in qlikview

alexpanjhc — Tue, 02 Oct 2012 21:15:25 GMT

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?

Re: resident function in qlikview

Tue, 02 Oct 2012 21:21:41 GMT

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

Re: resident function in qlikview

alexpanjhc — Tue, 02 Oct 2012 21:23:44 GMT

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

Re: resident function in qlikview

Tue, 02 Oct 2012 21:24:41 GMT

yes it was created earlier and it was not dropped

Re: resident function in qlikview

alexpanjhc — Tue, 02 Oct 2012 21:25:29 GMT

can you see this table in table viewer?

Re: resident function in qlikview

Tue, 02 Oct 2012 21:26:12 GMT

yes i can see A_B table in the datamodel

Re: resident function in qlikview

alexpanjhc — Tue, 02 Oct 2012 21:29:51 GMT

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

Re: resident function in qlikview

Tue, 02 Oct 2012 21:31:49 GMT

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

Re: resident function in qlikview

alexpanjhc — Tue, 02 Oct 2012 21:33:54 GMT

upload the qvw?

Re: resident function in qlikview

MayilVahanan — Tue, 02 Oct 2012 21:59:44 GMT

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..