Right join?

[#1]

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

[Gysbert_Wassenaar · Accepted solution]

Try

All:

SELECT * FROM all;

right join (All)

LOAD Personnr,

     email,

     kategori,

     created_at

FROM

....

;

[jvitantonio]

Of course you get all row, that's what you are doing. Try left join.

[#4]

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