Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
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
Valued Contributor II

Re: Fullouter join and concatenate

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

7 Replies
preminqlik
Valued Contributor II

Re: Fullouter join and concatenate

joining means getting data related to it....

concatenating means updating records...

qlikpahadi07
Valued Contributor

Re: Fullouter join and concatenate

Hi,

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

Not applicable

Re: Fullouter join and concatenate

hi prem,

can please give me clarification like joining to tables

suppose names sales and budget

and concatenating two tables.

israrkhan
Valued Contributor II

Re: Fullouter join and concatenate

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
Valued Contributor II

Re: Fullouter join and concatenate

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

Re: Fullouter join and concatenate

Hi,

This join works like SET-union

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

sakamsureshbabu
Contributor

Re: Fullouter join and concatenate

thanks