Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Right join?

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

1 Solution

Accepted Solutions
Gysbert_Wassenaar

Try

All:

SELECT * FROM all;

right join (All)

LOAD Personnr,

     email,

     kategori,

     created_at

FROM

....

;


talk is cheap, supply exceeds demand

View solution in original post

3 Replies
Gysbert_Wassenaar

Try

All:

SELECT * FROM all;

right join (All)

LOAD Personnr,

     email,

     kategori,

     created_at

FROM

....

;


talk is cheap, supply exceeds demand
jvitantonio
Luminary Alumni
Luminary Alumni

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

Not applicable
Author

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