topic Re: Jointure deux table Qlikview in QlikView

Jointure deux table Qlikview

Mon, 27 May 2013 12:22:10 GMT

hi,

I started with QlikView and i m looking for how I can join it between two tables
( nanturelle , left or right)

here is what i m doing now :

Pivot:

LOAD

prnum;

SQL SELECT

prstatus.prnum,

prline.prnum

FROM PRSTATUS prstat

JOIN PRLINE pr

ON pr.prnum = prstat.prnum;

thanks for help

--------------------------------------------------------------------------------------------------------------

Bonjour

je débute avec qlikview et je voudrais savoir comment je peut faire la jointure (nanturelle ou left ou right) entre deux tables

ci dessus le code que j exécute maintenat et ça marche pas

Merci

Re: Jointure deux table Qlikview

er_mohit — Mon, 27 May 2013 12:34:09 GMT

try like this

Temp:

load A,

C ;

SQL seleect * from table;

inner join// if you want data between two tables

Test1:

load A,

Z ,

SQL seleect * from table2;

hope it helps

Re: Jointure deux table Qlikview

Mon, 27 May 2013 12:56:36 GMT

in qlikview if two tables have the common field name then both table are automatically linked .

example

suppose i have two table.

Table1
A	B
1	aa
2	cc
3	ee

Table2
A	C
1	xx
4	yy

here field A is common in both so this auomatocally linked,

now i think you want that,

select all from both table where Table1.A = Table2.A

then for this in qlikview we achieve by inner join.

Table1:

load *;

Sql select * from table1;

inner join

load*;

Table2:

Sql select * from table2;

Then output like this

A	B	C
1	aa	xx

hope with the help of this example you will solve your problem.

Regards

vishwaranjan

Re: Jointure deux table Qlikview

Mon, 27 May 2013 13:00:03 GMT

thanks a lot for help but it dosn t work

"Échec de la connexion ODBC

SQL select * from prstatus"

Re: Jointure deux table Qlikview

Mon, 27 May 2013 13:01:45 GMT

yes but when we need to do a left join or a right join we need join statement i think !!!!