topic Re: Pulling in SQL Views into load script in QlikView

Pulling in SQL Views into load script

rtr13 — Tue, 03 Dec 2019 15:16:28 GMT

Is it possible to pull in SQL views into qlikview? I am currently running into errors saying Invalid object name. Any help is much appreciated!

Best,

Rose

Re: Pulling in SQL Views into load script

johnca — Tue, 03 Dec 2019 17:50:16 GMT

Are you prefacing the view with the associated schema it is in? I've found that is required in some cases, especially with Oracle databases. Like: SCHEMA.VIEW

HTH,
John

Re: Pulling in SQL Views into load script

Brett_Bleess — Wed, 11 Dec 2019 15:43:13 GMT

Did John's suggestion do the trick for your issue? If so, be sure you return to the thread and use the Accept as Solution button on his post to give him credit for the assistance and to let other Community Members know that worked.

The only other thing of which I can think is something in the DB Connector/Driver maybe, only other thing that comes to mind on this one. If you still need further help, leave an update.

Regards,
Brett