topic Re: Table not found in QlikView

Table not found

manoranjan_d — Thu, 12 May 2016 07:01:51 GMT

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

Re: Table not found

settu_periasamy — Thu, 12 May 2016 07:07:15 GMT

Can you post the Entire Script?

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

Check the Emp table exist or not?

Re: Table not found

manoranjan_d — Thu, 12 May 2016 07:11:02 GMT

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

Re: Table not found

avinashelite — Thu, 12 May 2016 07:18:03 GMT

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

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

Re: Table not found

MK_QSL — Thu, 12 May 2016 08:06:01 GMT

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?

Re: Table not found

manoranjan_d — Thu, 12 May 2016 08:33:02 GMT

Thanks

Re: Table not found

manoranjan_d — Thu, 12 May 2016 08:35:44 GMT

by using no concatenate i got the output

Re: Table not found

MK_QSL — Thu, 12 May 2016 08:39:51 GMT

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?

Re: Table not found

Anonymous — Thu, 12 May 2016 08:59:11 GMT

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_l=serp.3..33i21.6158…

Re: Table not found

avinashelite — Thu, 12 May 2016 09:16:09 GMT

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