Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
deepakqlikview_123
Specialist
Specialist

Join and concatenate in qlikview

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,

1 Solution

Accepted Solutions
maxgro
MVP
MVP

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

];

1.png

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

];

2.png

View solution in original post

7 Replies
anbu1984
Master III
Master III

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

maxgro
MVP
MVP

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

];

1.png

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

];

2.png

CELAMBARASAN
Partner - Champion
Partner - Champion

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.

ashfaq_haseeb
Champion III
Champion III

Hi,

have a look at below post

QlikView Joins

regards

ASHFAQ

crusader_
Partner - Specialist
Partner - Specialist

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

AbhijitBansode
Specialist
Specialist

refer below link for use case difference between the two:

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

Not applicable

Thanks. Very helpful post!

Regards,

KC