Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

1 Solution

Accepted Solutions
israrkhan
Specialist II
Specialist II

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....

View solution in original post

7 Replies
preminqlik
Specialist II
Specialist II

joining means getting data related to it....

concatenating means updating records...

qlikpahadi07
Specialist
Specialist

Hi,

You can go to Help in Qlikview Developer where you will find a perfect demonstration of joins with Example.

Not applicable
Author

hi prem,

can please give me clarification like joining to tables

suppose names sales and budget

and concatenating two tables.

israrkhan
Specialist II
Specialist II

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....

VishalWaghole
Specialist II
Specialist II

Hi Mahesh,

Suppose you have this 2 tables. Table1 and Table2

Table1 is

A
B
C
111
222
333

Table2 is

A
B
D
222
333
555


Inner join result you like

A
BCD
2222
3333


Left join result you like

A
BCD
1111
2222
3333


right join result you like

A
BCD
2222
3333
55

5

Outer join result you like

A
BCD
111
2222
3333
555

Concatenate give result like

A
BCD
111
222
333
222
333
555

Hope it will help you to clear your join and concatenate concept.

- Regards,

Vishal Waghole

Not applicable
Author

Hi,

This join works like SET-union

And Concatenate just enlarges the table at the end one after another

sakamsureshbabu
Creator
Creator

thanks