Table not found

[manoranjan_d]

A:

Load  Distinct

name,

emp id,

sal,

desg

RESIDENT Emp;

INNER JOIN

LOAD

Distinct

name,

empid,

max(date) as latest date

RESIDENT A

group by name,

emp id;

I m getting table not found error while running the script

[settu_periasamy]

Can you post the Entire Script?

Is your 'A' table is loading without Inner Join?

Check the Emp table exist or not?

[manoranjan_d]

emp table is exist only i m getting error on resident table

[avinashelite]

I think you table A is getting merged with another table thats why your not able to get the table A ...try like this

NOCONCATENATE

A:

Load  Distinct

name,

[emp id,]

sal,

desg

RESIDENT Emp;

INNER JOIN

LOAD

Distinct

name,

[emp id],

max(date) as latest date

RESIDENT A

group by name,

[emp id];

[MK_QSL]

A:

Load  Distinct

name,

emp id,

sal,

desg

RESIDENT Emp;

INNER JOIN

LOAD

Distinct

name,

empid,

max(date) as latest date

RESIDENT A

group by name,

emp id;

WHERE IS DATE FIELD IN TABLE A?

[manoranjan_d]

Thanks

[manoranjan_d]

by using no concatenate i got the output

[MK_QSL]

Are you sure?

Inner Join is using max(date) RESIDENT A...

Table A don't have date field !!!

I am surprised but as far as you got the solution, OK for me!

Can you share your screenshot or script which is working now?

[Anonymous]

may be it is useful to you

https://www.google.co.in/search?q=table+isnot+found+in+qlikview&oq=table+isnot+found+in+qlikview&gs_...

[avinashelite]

mrkachhiaimp‌ I think he has we have not got the rite script

manoranjan.d If you have got the answer mark the correct answer and close this thread