What is difference between concatenate & join?

[#1]

What is difference between concatenate & join? Please help me...

[its_anandrjs]

Hi,

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

Regards

Anand

[#3]

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

[#4]

Understanding Join, Keep and Concatenate

Best thread with examples

[#5]

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)

[#6]

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

[Anonymous]

JOIN  - Joins will join the whole table and fields.

Concatenate - Fields only concatenate to which same fields.

[Miguel_Angel_Baeyens]

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.