Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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