Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Re: What is difference between concatenate & join?

Hi,

If you got correct answer from the post then mark it correct or helpful and close the thread.

Regards

Anand

Not applicable

Re: What is difference between concatenate & join?

join:

here we can join the tables based on the common key fields

1)outerjoin(default join in qlikview)

2)right join

3)left join

4)inner join

concatenation:

here we have concatenation, no concatenation,automatic  concatenation.

concatenation: combining the two tables if no common fields

automatic conc:  if  fields are same then automatically it gets concatenation

'no concatenation:   if  fields are same then automatically it gets concatenation to avoid this we will go for noconcatenate

finally both  will gives the product table only(menas combination of 2 tables)

join will join the 2 tables  and  concatenate will concatenate the 2 tables

answer ok aithe correct answer ga select cheyi , endhukante andharu points kosam waiting

Highlighted
Not applicable

Re: What is difference between concatenate & join?

Understanding Join, Keep and Concatenate

Best thread with examples

Not applicable

Re: What is difference between concatenate & join?

Hi Pavani,

Join--- Horizontal merging of the morethan 1 table (Like Join in SQL)

Concatenate ---- vertical merging of morethan 1 table(like union in SQL)

Not applicable

Re: What is difference between concatenate & join?

HI Pavani,

JOIN - Joins will joins the fields and Field values

where Concatenate Appends the data with existing data.

if you need further clarification i will send you an email just provide your email.

Venkat

nithya123
New Contributor II

Re: What is difference between concatenate & join?

JOIN  - Joins will join the whole table and fields.

Concatenate - Fields only concatenate to which same fields.

MVP
MVP

Re: What is difference between concatenate & join?

That's not actually accurate. CONCATENATE does create the missing fields from one table into another and adds all the rows, but these are empty or null of they don't have a corresponding field in the concatenated table.

Think of CONCATENATE like an append instruction which add rows no matter the relation the two tables have (as opposed to JOIN, where there must be some type of relation between the tables).

You could indeed concatenate whatever table in the data model to any other table and the result would be a bigger table with as many columns as those in both tables and as many rows as those in each table.

Community Browser