Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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
MVP & Luminary
MVP & Luminary

Re: Right join?

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
MVP & Luminary
MVP & Luminary

Re: Right join?

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

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