topic Re: What is difference between concatenate & join? in QlikView

What is difference between concatenate & join?

Sun, 02 Nov 2014 10:15:21 GMT

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

Re: What is difference between concatenate & join?

MK_QSL — Sun, 02 Nov 2014 10:20:04 GMT

Understanding Join, Keep and Concatenate

Concatenate,Left Join, Left Keep

Re: What is difference between concatenate & join?

ashfaq_haseeb — Sun, 02 Nov 2014 10:24:07 GMT

Hi,

Check this

http://community.qlik.com/docs/DOC-6562

http://community.qlik.com/thread/39177

http://community.qlik.com/thread/134760

Regards

ASHFAQ

Re: What is difference between concatenate & join?

its_anandrjs — Sun, 02 Nov 2014 10:40:58 GMT

Hi,

There are many post relate to the Concatenation and Joins have a look at some of use full Concatenation and join documents

Diffrence between Concatenate and Join???

http://community.qlik.com/blogs/qlikviewdesignblog/2013/05/17/concatenate-vs-link-table

Regards

Anand

Re: What is difference between concatenate & join?

Sun, 02 Nov 2014 12:03:58 GMT

Thank you......

Re: What is difference between concatenate & join?

ashfaq_haseeb — Sun, 02 Nov 2014 12:04:40 GMT

Hi,

Can you close this thread by selecting appropriate answers.

Regards

ASHFAQ

Re: What is difference between concatenate & join?

Sun, 02 Nov 2014 12:04:52 GMT

Thankqqqqqqqqqqq

Re: What is difference between concatenate & join?

IAMDV — Sun, 02 Nov 2014 13:54:01 GMT

Hi,

Few video tutorials on the same subject.

http://qlikshare.com/qlikview-video-tutorial-concatenate-noconcatenate-operators-qlikview/

http://qlikshare.com/877/

Cheers,

Re: What is difference between concatenate & join?

Nagaraju_KCS — Tue, 04 Nov 2014 10:42:52 GMT

Hi Pavani,

Simple Defination..

Join: Join will combine the rows where the key values matches..

table1: table2:

ID name ID Sal

1 ABC 1 10000

2 CBD 3 20000

Output:

ID Name sal

1 ABC 10000

2 CBD -

3 - 20000

Concatenate: Concatenate append the rows of one table to another table, concatenate never merges any row in it..

Output:

ID Name sal

1 ABC -

2 CBD -

1 - 10000

3 - 20000

Hope it helps...............

Re: What is difference between concatenate & join?

Anonymous — Tue, 04 Nov 2014 11:35:42 GMT

Hey,

You may check this as well.

Join and concatenate in qlikview | Qlik Community

Re: What is difference between concatenate & join?

its_anandrjs — Tue, 04 Nov 2014 14:05:40 GMT

Hi,

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

Regards

Anand

Re: What is difference between concatenate & join?

Tue, 04 Nov 2014 14:20:52 GMT

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

Re: What is difference between concatenate & join?

Tue, 04 Nov 2014 14:22:43 GMT

Understanding Join, Keep and Concatenate

Best thread with examples

Re: What is difference between concatenate & join?

Tue, 04 Nov 2014 14:52:40 GMT

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)

Re: What is difference between concatenate & join?

Tue, 04 Nov 2014 15:40:34 GMT

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

Re: What is difference between concatenate & join?

Anonymous — Thu, 20 Oct 2016 06:45:28 GMT

JOIN - Joins will join the whole table and fields.

Concatenate - Fields only concatenate to which same fields.

Re: What is difference between concatenate & join?

Miguel_Angel_Baeyens — Thu, 20 Oct 2016 10:48:53 GMT

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.