when should we use join ,keep and concatenate ? almost all giving same result

[#1]

when should we use join ,keep and concatenate ? almost all giving same result

join gives product table 

kepp maintain reation ship

concatenate  appending rows  

is there any other facilities to use join ,keep ,concatenate

[avinashelite]

Hi Manoj,

If the data is less we can use concatenation, but if the data is huge it will create lot of junk records which will increase the size of your application and effect the performance.

Join: Join will help you to filter out the records based on the common values  between the table concatenation will not do that eg LEFT, RIGHT joins etc

Please go through this attachment for more details

Regards,

@vi

[ThornOfCrowns]

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

[rbecher]

Take a look into the online help. It explains and contains examples!