Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Joins ?

In How many ways we can use Inner join ?

as well as Left Join ?

4 Replies
thornofcrowns
Valued Contributor II

Re: Joins ?

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.

Not applicable

Re: Joins ?

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

arsal_90
Contributor III

Re: Joins ?

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

arsal_90
Contributor III

Re: Joins ?

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

Community Browser