topic Re: Join and concatenate in qlikview in QlikView

Join and concatenate in qlikview

deepakqlikview_123 — Tue, 23 Sep 2014 10:15:56 GMT

Hi,

For joining two tables one filed should be comman in between two tables.

For concatenating tables is such kind of condition is there,

what will happen if all fields are different while concatenating two tables.

Is it synbol of good practice for development.

Thanks,

Re: Join and concatenate in qlikview

anbu1984 — Tue, 23 Sep 2014 10:30:24 GMT

Join - Merge rows

In Join, if you dont have common field, then cartesian product happens

Tab1:

Load * Inline [

A,B

1,1

2,2 ];

Join

Load * Inline [

C,D

1,1

2,2 ];

Concatenate - Add rows

Tab2:

Load * Inline [

A1,B1

1,1

2,2 ];

Concatenate

Load * Inline [

C1,D1

1,1

2,2 ];

Understanding Join, Keep and Concatenate

Re: Join and concatenate in qlikview

maxgro — Tue, 23 Sep 2014 10:36:02 GMT

1) For joining two tables one filed should be comman in between two tables.

sometimes no

t1:

load * inline [

f1, f2

1,a

2,b

];

join (t1)

load * inline [

f3, f4

10,aa

20,bb

30,cc

];

2) For concatenating tables is such kind of condition is there,

what will happen if all fields are different while concatenating two tables.

no condition as you can force concat

t1:

load * inline [

f1, f2

1,a

2,b

];

concatenate (t1)

load * inline [

f3, f4

10,aa

20,bb

30,cc

];

Re: Join and concatenate in qlikview

CELAMBARASAN — Tue, 23 Sep 2014 10:36:04 GMT

Two different concatenation is there Auto Concatenation and Force Concatenation

Auto Concatenation:

When Qlikview sees the two different tables with same number of fields and same field names. It will concatenated in to single table by itself.

Forced Concatenation:

Using Concatenate keyword before the Load statement. For the non-common fields between two tables will have the NULL value in other table rows.

Re: Join and concatenate in qlikview

ashfaq_haseeb — Tue, 23 Sep 2014 10:37:31 GMT

Hi,

have a look at below post

QlikView Joins

regards

ASHFAQ

Re: Join and concatenate in qlikview

crusader_ — Tue, 23 Sep 2014 10:42:09 GMT

Hi,

Anbu's post explains difference between join|keep|concatenate.

Concatenating fact tables with some different fields is acceptable for creating sophisticated Data scheme,

it is not out of best practice, just depends on complexity of your ap

Andrei

Re: Join and concatenate in qlikview

AbhijitBansode — Tue, 23 Sep 2014 10:43:50 GMT

refer below link for use case difference between the two:

http://qlikviewcookbook.com/2009/11/understanding-join-and-concatenate/

Re: Join and concatenate in qlikview

Tue, 19 May 2015 12:04:14 GMT

Thanks. Very helpful post!

Regards,