topic Re: Fullouter join and concatenate in QlikView

Fullouter join and concatenate

Sun, 29 Dec 2013 07:03:31 GMT

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

preminqlik — Sun, 29 Dec 2013 07:48:05 GMT

joining means getting data related to it....

concatenating means updating records...

Re: Fullouter join and concatenate

qlikpahadi07 — Sun, 29 Dec 2013 07:54:31 GMT

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

Sun, 29 Dec 2013 08:07:04 GMT

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

israrkhan — Sun, 29 Dec 2013 08:37:12 GMT

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

Re: Fullouter join and concatenate

VishalWaghole — Sun, 29 Dec 2013 08:52:00 GMT

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

Re: Fullouter join and concatenate

Sun, 29 Dec 2013 10:22:51 GMT

Hi,

This join works like SET-union

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

Re: Fullouter join and concatenate

sakamsureshbabu — Wed, 24 Dec 2014 07:50:37 GMT

thanks