Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How can we combine SQL query and Qlikview Query

This is the scenario

Table1:

Load

EMP_Id,

EMP_Name

SQL Select

emp_id,

emp_name

from employee;

temp_tabe:

load sal,emp_id

resident salry;

Table3:

load address

emp_id

resident table1;

The case is need to merge all the tables.

1 Solution

Accepted Solutions
Not applicable
Author

Table1:

Load

EMP_Id,

EMP_Name

SQL Select

emp_id,

emp_name

from employee;

 

join(Table1) load

emp_id as _EMP_Id,

sal

resident salry;

join(Table1) load

emp_id as EMP_Id,

address

resident ???;

View solution in original post

3 Replies
Not applicable
Author

Table1:

Load

EMP_Id,

EMP_Name

SQL Select

emp_id,

emp_name

from employee;

 

join(Table1) load

emp_id as _EMP_Id,

sal

resident salry;

join(Table1) load

emp_id as EMP_Id,

address

resident ???;

Not applicable
Author

Then will it create synthetic keys for emp_id?

Not applicable
Author

No it will not create the Synthetic key ...