Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

SQL - Missing tables?

Hi, I'm starting with QLIK and doing some test where I'm connecting via ODBC to a database, but when I'm selecting data, I'm unable to find one particular table. If I go via SQL management Studio and with exactely the same SQL user, I can see this table...

I even got another identical database under the same instance and schema, where I can find this particular table, but on this DB it doesn't show up on the "Add Data" menu.

What can be the reasons for this?? Any hints from more experienced users??

Thanks in advance for your help!

Carlos Silva

Tags (1)
1 Solution

Accepted Solutions
Not applicable

Re: SQL - Missing tables?

Thanks for your tips. Don't know what happened but the table is available now. I suspect it was "missing" because i now realized that when using the scroll Wheel it jumps lines/tables from one window to another.

Thanks,

Carlos Silva

5 Replies
MVP
MVP

Re: SQL - Missing tables?

If possible try to connect with OLEDB rather than ODBC.

sinanozdemir
Valued Contributor III

Re: SQL - Missing tables?

Make sure to choose the correct schema in the create select statement window:

Capture.PNG

And also check the appropriate check boxes as well.

Capture.PNG

MVP
MVP

Re: SQL - Missing tables?

try to paste the query that work in SQL Management Studio in QlikView editor

SQL

select ....... from ..........;

reload and post the error

Not applicable

Re: SQL - Missing tables?

Thanks for your tips. Don't know what happened but the table is available now. I suspect it was "missing" because i now realized that when using the scroll Wheel it jumps lines/tables from one window to another.

Thanks,

Carlos Silva

MVP
MVP

Re: SQL - Missing tables?

ok, please close the thread marking (I think your answer) correct and/or helpful answers, thanks