7 Replies Latest reply: Dec 24, 2014 2:50 AM by Suresh Babu

# 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

• ###### Re: Fullouter join and concatenate

joining means getting data related to it....

concatenating means updating records...

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

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

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

a, b

1,2

2,3

];

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.

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

• ###### 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

- Regards,

Vishal Waghole

• ###### Re: Fullouter join and concatenate

thanks

• ###### Re: Fullouter join and concatenate

Hi,

This join works like SET-union

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