topic custom SQL join in qlikview in QlikView

custom SQL join in qlikview

manoj217 — Tue, 20 Mar 2018 06:51:23 GMT

Hi All,

I want to join two tables in custom SQL In Qlikview , can anyone please help me how to join two tables and I don't want the preceding load, I want only custom SQL. help with an example syntax

My data Base is Oracle not a SQL is it possible to do Custom sql in Qlikview.

Thanks,

Manoj

Re: custom SQL join in qlikview

Qrishna — Tue, 20 Mar 2018 06:54:45 GMT

First define your connection,(it would be something like below)

OLEDB CONNECT32 TO [Provider=SQLOLEDB.1;

and then select the table or view:

Table:

SQL

SELECT * from tttt;

It doesnot matter what data source it is oracle or netezza or teradata until you can execute/accepts a sql statement at the database level.

Re: custom SQL join in qlikview

Qrishna — Tue, 20 Mar 2018 06:57:46 GMT

Dont duplicate the threads.

Custom SQL join in qlikview

please close/delete the other duplicate thread.

Re: custom SQL join in qlikview

manoj217 — Tue, 20 Mar 2018 07:01:37 GMT

I want to join two tables in custom sql itself

Re: custom SQL join in qlikview

Qrishna — Tue, 20 Mar 2018 07:05:08 GMT

Yes you can perform join logics just the way you do in sql server/TOAD .

Just add a prefix SQL as shown above and you write your own sql queries.

eg:

Table:

SQL

SELECT * from tttt

join Table 2 Where Table1.Field = Table2.Field;

Re: custom SQL join in qlikview

manoj217 — Tue, 20 Mar 2018 07:08:09 GMT

for oracle database SQL is necessary, because while connecting the oracle database It will generates only Select * from table.

Re: custom SQL join in qlikview

Qrishna — Tue, 20 Mar 2018 07:12:04 GMT

yes thats what i was saying.add a prefix SQL and write whatever query you want.no matter what it is.oracle or sql or netezza untill your database accepts your SQL query.

Re: custom SQL join in qlikview

manoj217 — Tue, 20 Mar 2018 07:42:51 GMT

i hv wrote the same oracle query into the qlikview but it is showing error. i hv copy pasted the oracle query into the qlikview

Re: custom SQL join in qlikview

sasiparupudi1 — Tue, 20 Mar 2018 09:26:46 GMT

Please paste you sql and the error here