Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
dreweezy
Contributor

loading in a table and a view from the same database

Does Qlik Sense have the capability to satisfy this need? My current data in QS is using many views, but I have tried to bring in just one table from the same database connection but errors me out. I tried to do a simple 'outer join' on this table to another view (both the table and view have a common field). I've tried using the data model viewer to bring in this new table but get an error stating data profiling error. Is QS not able to use both tables and views from a database and only of the other? 

Labels (5)
1 Reply
crusader_
Valued Contributor

Re: loading in a table and a view from the same database

Hi,

QlikSense definitely can read everything (tables, views, files) from the same or multiple DBs from anywhere (on prem/Cloud) in single application.

Attach screenshot of error + log files so others could analyze it and provide any valuable response.

//Andrei