Discussion Board for collaboration related to QlikView App Development.
Hi,
How do I do if I only want to join the rows in table "All" if they can be found in table "Active"?
If I hade a sql query I would join my tables like:
select * from
All all
right join Active active on all.email=active.email_adress
...
I want all the rows in table "Active" to be shown and combined with table "All".
If the row is only found in "All" it should not be included.
In qlikview I try to do it like below, but I still got all rows from "All", dispite if they match or not.
//All:
right Join (Active)
LOAD Personnr,
email,
kategori,
created_at
FROM
....
;
How do I do it?
/Julia
Try
All:
SELECT * FROM all;
right join (All)
LOAD Personnr,
email,
kategori,
created_at
FROM
....
;
Try
All:
SELECT * FROM all;
right join (All)
LOAD Personnr,
email,
kategori,
created_at
FROM
....
;
Of course you get all row, that's what you are doing. Try left join.
Thanks for your help!
I tried it before (with left) but I might have been confuse about the information that is given in the script execution -window.(wish is now stuck). The script execution window doesnt give any information about the combined table... only about the separate tables in the script?
/Julia