topic Re: how to load a view directly into qlikview from sql server in QlikView

how to load a view directly into qlikview from sql server

trishita — Wed, 02 May 2018 10:57:29 GMT

SQL SELECT *
FROM FSCDB."MO_PURCH_SOUNDING_CORRECTION_VIEW";

But its showing me error

Re: how to load a view directly into qlikview from sql server

sasiparupudi1 — Wed, 02 May 2018 11:00:00 GMT

What is the error you are getting?

Re: how to load a view directly into qlikview from sql server

sasiparupudi1 — Wed, 02 May 2018 11:00:47 GMT

May be try seleting few fields to see if it works

SQL SELECT

F1,

F2
FROM FSCDB.MO_PURCH_SOUNDING_CORRECTION_VIEW

;

Re: how to load a view directly into qlikview from sql server

trishita — Wed, 02 May 2018 11:08:00 GMT

do I need to set any variables?

Re: how to load a view directly into qlikview from sql server

trishita — Wed, 02 May 2018 11:09:22 GMT

Database not found error

There is no open data connection.

SQL SELECT *

FROM FSCDB."MO_PURCH_SOUNDING_CORRECTION_VIEW"

Re: how to load a view directly into qlikview from sql server

prma7799 — Wed, 02 May 2018 11:11:34 GMT

try like this

TableName:

LOAD *;

SQL SELECT *
FROM FSCDB."MO_PURCH_SOUNDING_CORRECTION_VIEW";

Re: how to load a view directly into qlikview from sql server

awhitfield — Wed, 02 May 2018 11:18:08 GMT

So.... have you actually created an ODBC or OLEDB connection to the server / DB?

Andy

Re: how to load a view directly into qlikview from sql server

sasiparupudi1 — Wed, 02 May 2018 11:23:02 GMT

ODBC CONNECT TO YOURODBC ;

SQL SELECT *

FROM FSCDB."MO_PURCH_SOUNDING_CORRECTION_VIEW"

Re: how to load a view directly into qlikview from sql server

trishita — Wed, 02 May 2018 11:28:04 GMT

yes and I am logging into the specific database with userid and passwort as well

Re: how to load a view directly into qlikview from sql server

awhitfield — Wed, 02 May 2018 11:40:02 GMT

So... did you the "Select" button to create your query?

AFAIK you still haven't confirmed what the error is! What is it?

Andy

Re: how to load a view directly into qlikview from sql server

trishita — Thu, 03 May 2018 11:26:03 GMT

every thing is working fine.Thanks

Re: how to load a view directly into qlikview from sql server

prma7799 — Thu, 03 May 2018 11:30:15 GMT

If you get your answer please mark helpful or correct answer .