topic Re: Joins ? in QlikView

Joins ?

Mon, 24 Mar 2014 10:18:35 GMT

In How many ways we can use Inner join ?

as well as Left Join ?

Re: Joins ?

ThornOfCrowns — Mon, 24 Mar 2014 10:26:42 GMT

In a LEFT join, all the records from the first table are kept, and only those records from the second table that match a record in the first table are kept.

In an INNER join, only records with a match across both tables will be kept.

Re: Joins ?

Mon, 24 Mar 2014 10:46:40 GMT

we can join tables with table names, is it possible to join with cloumn names?

Re: Joins ?

arsal_90 — Mon, 24 Mar 2014 10:50:10 GMT

yes it is possible to join with column name i mean you just have Key column in both tables on which you make your join.

Example:

Load A,
B,

C from ABC1.xls

left join

Load A,

D from ABC2.xls

Re: Joins ?

arsal_90 — Mon, 24 Mar 2014 10:51:53 GMT

Inner Join:

Example:

Load A,
B,

C from ABC1.xls

inner join

Load A,

D from ABC2.xls

Inner Join take all data where data matches in both table and left join take all data from left table