Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
try like this
Temp:
load A,
B,
C ;
SQL seleect * from table;
inner join// if you want data between two tables
Test1:
load A,
B,
Z ,
D,
E;
SQL seleect * from table2;
hope it helps
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
thanks a lot for help but it dosn t work
"Échec de la connexion ODBC
SQL select * from prstatus"
yes but when we need to do a left join or a right join we need join statement i think !!!!