What is difference between concatenate & join?

[#1]

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

[MK_QSL · Accepted solution]

Understanding Join, Keep and Concatenate

Concatenate,Left Join, Left Keep

[ashfaq_haseeb]

Hi,

Check this

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

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

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

Regards

ASHFAQ

[its_anandrjs]

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

[#5]

Thank you......

[ashfaq_haseeb]

Hi,

Can you close this thread by selecting appropriate answers.

Regards

ASHFAQ

[#7]

Thankqqqqqqqqqqq

[IAMDV]

Hi,

Few video tutorials on the same subject.

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

http://qlikshare.com/877/

Cheers,

DV

[qv_testing]

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...............

[Anonymous]

Hey,

You may check this as well.

Join and  concatenate in qlikview | Qlik Community