topic Re: Joins result issue in QlikView

Joins result issue

Fri, 28 Aug 2015 10:50:00 GMT

i have 2 tables .the first table consist of 20 records and second contains 30 records what would be the result if i apply left join ,right join,inner join and outer join.

Thanks & regards

raja

Re: Joins result issue

marcus_malinow — Fri, 28 Aug 2015 10:54:02 GMT

Raja,

this very much depends on the data itself, in particular which fields you are joining on.

Suggest that you take a look at this article - Different Join Functions in Qlikview

Also, use the search function before posting simple questions like this, you'll get an answer quicker and avoid spamming the board.

Marcus

Re: Joins result issue

parthakk — Fri, 28 Aug 2015 10:58:10 GMT

Hi Raja,

The result of join depends upon the similarity between your records/ fields. In general

Left join gives priority to left tables( say Table1)

Right join gives priority to right tables( say Table2)

Inner join fetches the value that are common in both the tables

Outer join combines both tables...

Thanks,

Partha Kulkarni

Re: Joins result issue

Anonymous — Fri, 28 Aug 2015 11:06:05 GMT

hi raja,

Please see below post:

Some Qlikview Joins best documents

left join loads all 20 records from first table and matching records from second table.

Right join loads all 30 records from second table and matching records from first table.

Inner join loads all matching records from first and second table .

outer join loads all records from first and second table.

Regards

Neetha

Re: Joins result issue

jonathandienst — Fri, 28 Aug 2015 11:12:39 GMT

I suggest that you create a small qvw with in-line loads for two test tables and try out all the options yourself. If you work with that, the manual, existing articles and threads already in the forum and (as a last resort) specific questions on the forum, you will quickly master these concepts.