sql and qlikview join

[#1]

Hi,

I need to implement replica of BO report in Qlikview which has below SQL, I have loaded the two tables , can I link two tables in Qlikview by renaming column same as join condition mentioned in SQL query

Select col1,col2

From table1,table2

where

table1.col1=table2.col2

[jpenuliar]

Hi Vibhu,

provided you have created your ODBC connection, your sql join may look like below:

test:

SQL

SELECT

    table1.column1,

    table2.column2...

FROM

    table1,

    table2

Where

    table1.common_field (+)= table2.common_field

;

[vishsaggi]

What is your expected output, any chance of sending that information to us?

I usually do this if am using SQL databases.

LOAD *;

SQL Select T1.Col1, T1.Col2,

                  T2.Col1, T2.Col2

        FROM Table1 T1

        LEFT JOIN or INNER JOIN

                   Table2 T2

                   ON T1.Col1 = T2.Col1 ;

[maxgro]

post a small example (.qvw) to demonstrate the problem

[#5]

Hi,

I got the answer...means we can manually type the SQL after Load statement , am I correct?

[vishsaggi]

Yes, with a SQL clause before Select.

[#7]

Hi ,

I have below SQL query which I need to implement in Qlikview , I have created qvd for each table with incremental load applied on each qvd, can I implement above mentioned approach for implementing below query means first load data from qvd using LOAD statement for each table and then implement SQL joins between tables along with conditions as shown below after load statement

SQL:

Select table1.col1, table2.col2,table3.col3

from table1,table2,table3

where table1.col1=table2.col2

and table1.col2=table2.col4(+)

and table1.col3=table2.col6(+)

and table2.col1=table3.col2(+)

and table2.col3=table3.col4(+)

and table2.col5=table3.col6(+)

and table1.col5='ABC'

and table2.col5='ABC'

and table3.col5='ABC'

[vishsaggi]

No i did not realize your are getting tables from QVD's. SQL clause works for any relational databases with a connecting string. I doubt if it works like that. How many qvd's you have and you dont need a SQL when we can form relations in Qlikview by creating a star schema with facts and dimension tables. What exactly you are trying to achieve can you please elaborate a little ?

[#9]

we are creating replica of BO report  in qlikview , we have implemented qvd with incremental load for some tables, database is oracle and it is ODS