Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

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 (2)
2 Replies
Highlighted
Contributor II
Contributor II

Hola, como estas?? 

intentaste levantar en memoria y despues hacer el join?? 

 

seria como un :

vista1:

load *;

sql select *

from algo.algo // view table 1 

;

 

no concatenate // 

vista2:

load * ;

sql select * 

from algo.algo2;// view table 12

join(vista2)

load * 

resident vista1;

drop table vista1;

esto deberia hacer el outer join que vos necesitas.

 

Saludos!!!!!!!!

 

Highlighted
Partner
Partner

Gracias,

veo lo que dices.. 

Tambien es genial que podamos comunicarnos! gracis traductor de Google!