topic Re: Right join? in QlikView

Right join?

Thu, 22 Nov 2012 13:58:26 GMT

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

Re: Right join?

Gysbert_Wassenaar — Thu, 22 Nov 2012 14:01:39 GMT

Try

All:

SELECT * FROM all;

right join (All)

LOAD Personnr,

email,

kategori,

created_at

FROM

....

;

Re: Right join?

jvitantonio — Thu, 22 Nov 2012 14:01:50 GMT

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

Re: Right join?

Thu, 22 Nov 2012 15:10:19 GMT

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