Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Fiorrie
Creator
Creator

Combine Load & SQL Query

Hi Everyone

I am trying to connect Load and SQL Statement after I drop the table (so not using concatenate as I am not using star scheme in this case). I want to connect additional dimension to existing model through ID. Can you advise please?

Many thanks

question.jpg

 

2 Solutions

Accepted Solutions
rubenmarin

Hi, sometimes you can load directly from SQL but I always set a LOAD before, so maybe to do a join you must use a load?:

Left Join
LOAD *;
SQL SELECT...

 

View solution in original post

Kushal_Chawda

@Fiorrie  or you can also do

Sql_query:

SQL SELCT *...   ;

right join

LOAD *

FROM Level_Table;

View solution in original post

2 Replies
rubenmarin

Hi, sometimes you can load directly from SQL but I always set a LOAD before, so maybe to do a join you must use a load?:

Left Join
LOAD *;
SQL SELECT...

 

View solution in original post

Kushal_Chawda

@Fiorrie  or you can also do

Sql_query:

SQL SELCT *...   ;

right join

LOAD *

FROM Level_Table;

View solution in original post