topic How can we combine SQL query and Qlikview Query in QlikView

How can we combine SQL query and Qlikview Query

Wed, 12 Sep 2012 05:21:26 GMT

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.

Wed, 12 Sep 2012 06:18:02 GMT

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 ???;

Wed, 12 Sep 2012 06:46:10 GMT

Then will it create synthetic keys for emp_id?

Wed, 12 Sep 2012 07:02:55 GMT

No it will not create the Synthetic key ...