Joins
Joins in QlikView are similar to joins in SQL. Joins between two tables always result in one table. With joins, the columns of the two tables are affected. Joins are explicitly made by using inner join, left join, right join, and outer join.
In QlikView, joins work in the following ways:
- Inner join: Only the matching records in the two tables are stored.
- Left join: All the records from the first/left table are kept, and only those records from the second table that match a record in the first table are kept.
- Right join: All the records from the second/right table are kept, and only those records from the first table that match a record in the second table are kept.
- Outer join or join: Records from both the tables will be stored and, where possible, records will be matched.
Tip
Use
Joins.qvwto practice different kinds of joins and concatenate options. It is located in yourAppsfolder.
Join Orders and Order Detail
The Orders
and Order Detail tables will be joined because an optimized data...
