Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

Tags (2)
1 Solution

Accepted Solutions

Re: Right join?

Try

All:

SELECT * FROM all;

right join (All)

LOAD Personnr,

     email,

     kategori,

     created_at

FROM

....

;


talk is cheap, supply exceeds demand
3 Replies

Re: Right join?

Try

All:

SELECT * FROM all;

right join (All)

LOAD Personnr,

     email,

     kategori,

     created_at

FROM

....

;


talk is cheap, supply exceeds demand
Luminary
Luminary

Re: Right join?

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

Not applicable

Re: Right 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


Community Browser