Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
vijaysahu2
Creator
Creator

How to Join two diffrent source datbase tables

Hi All

We have view created in SQL Server and two SQL tables are used in that, but because of my migration project

Underlying table are distributed in SQL and Oracle .

Below is the tables and join used in SQL server -  QV and Master tables

SELECT UPPER(Name) AS 'LINK', [Exec], DisplayName, 'Div' AS 'PermissionRule'

FROM QV Q

JOIN ( SELECT DISTINCT 'JB' AS 'Entity', [Name] AS 'Exec'

FROM Master

WHERE Division = 'JB' ) T ON 'JB' = T.Entity

WHERE QVAppID = 3 AND AllJEBData = 1

Because of this Migration QV table is left in SQL and Master table  is coming from Oracle. Now I have build above query in Qlikview, for this I have fetched data from SQL and Oracle in separate Qlikview Tables  but can not build this join

 

Please suugest

 

 

 

2 Replies
wandererroch
Contributor III
Contributor III

In Qlikview you would have to load them separately and join the resulting tables.

I've also made things like this work using linked servers and ODBC connections and doing the query on either the oracle or sql server directly.
vijaysahu2
Creator
Creator

Linked server is not approved in my project and this logic needs to be build in Qlikview only. I tried something like below but not sure if it will give the same result or not.

$(Include=..\inputdata\QlikviewDBCon.txt);

call SQLConnnection;

QV:
Load *;
SQL SELECT UPPER(Name) AS 'LINK', DisplayName, 'Div' AS 'PermissionRule'
FROM QV Q WHERE QVAppID = 3 AND AllJEBData = 1;

$(Include=..\inputdata\salescon.txt);

call OracleConnection;

Inner JOIN(QV)

JEB:
Load *;
SQL SELECT
distinct 'JB' AS "Entity", name AS "Exec"

FROM
[master]

WHERE Division = 'JB';