
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Fullouter join and concatenate
Hi,can any body let me know the difference between these two and give me scenarious.
one has individual impaortance while designing Datamodel
regards
Mahesh t
- Tags:
- new_to_qlikview
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Mahesh,
1) Concatenate :
concatenate appends the row of two tables into one, whether they have matching record or not.
let say.
load * Inline [
a, b
1,2
2,3
];
Concatenate load * Inline [
a, b
1,2
2,3
3,4
];
final table will have
a,b
1,2
2,3
1,2
2,3
3,4
2) Outer Join :
outer Join brings matching record as one record, and non matching from both tables
let say.
load * Inline [
a, b
1,2
2,3
7,8
];
outer Join load * Inline [
a, b
1,2
2,3
5,3
3,4
];
final table will have
a,b
1,2 (matching in both table so one record)
2,3 (matching in both table so one record)
7,8 (non matching from first table)
5,3 (non matching from second table)
3,4 (non matching from second table)
Hope it helps....


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
joining means getting data related to it....
concatenating means updating records...


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
You can go to Help in Qlikview Developer where you will find a perfect demonstration of joins with Example.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hi prem,
can please give me clarification like joining to tables
suppose names sales and budget
and concatenating two tables.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Mahesh,
1) Concatenate :
concatenate appends the row of two tables into one, whether they have matching record or not.
let say.
load * Inline [
a, b
1,2
2,3
];
Concatenate load * Inline [
a, b
1,2
2,3
3,4
];
final table will have
a,b
1,2
2,3
1,2
2,3
3,4
2) Outer Join :
outer Join brings matching record as one record, and non matching from both tables
let say.
load * Inline [
a, b
1,2
2,3
7,8
];
outer Join load * Inline [
a, b
1,2
2,3
5,3
3,4
];
final table will have
a,b
1,2 (matching in both table so one record)
2,3 (matching in both table so one record)
7,8 (non matching from first table)
5,3 (non matching from second table)
3,4 (non matching from second table)
Hope it helps....


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Mahesh,
Suppose you have this 2 tables. Table1 and Table2
Table1 is
A | B | C |
---|---|---|
1 | 1 | 1 |
2 | 2 | 2 |
3 | 3 | 3 |
Table2 is
A | B | D |
---|---|---|
2 | 2 | 2 |
3 | 3 | 3 |
5 | 5 | 5 |
Inner join result you like
A | B | C | D |
---|---|---|---|
2 | 2 | 2 | 2 |
3 | 3 | 3 | 3 |
Left join result you like
A | B | C | D |
---|---|---|---|
1 | 1 | 1 | 1 |
2 | 2 | 2 | 2 |
3 | 3 | 3 | 3 |
right join result you like
A | B | C | D |
---|---|---|---|
2 | 2 | 2 | 2 |
3 | 3 | 3 | 3 |
5 | 5 | 5 |
Outer join result you like
A | B | C | D |
---|---|---|---|
1 | 1 | 1 | |
2 | 2 | 2 | 2 |
3 | 3 | 3 | 3 |
5 | 5 | 5 |
Concatenate give result like
A | B | C | D |
---|---|---|---|
1 | 1 | 1 | |
2 | 2 | 2 | |
3 | 3 | 3 | |
2 | 2 | 2 | |
3 | 3 | 3 | |
5 | 5 | 5 |
Hope it will help you to clear your join and concatenate concept.
- Regards,
Vishal Waghole

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
This join works like SET-union
And Concatenate just enlarges the table at the end one after another


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
thanks
