topic Re: Re: join and keep or both giving same result. only difference is join gives product table keep maintain the relationship tables are same? what scenario we have to use join and keep? advantages of using join and disadvantages? in QlikView

join and keep or both giving same result. only difference is join gives product table keep maintain the relationship tables are same? what scenario we have to use join and keep? advantages of using join and disadvantages?

Tue, 08 Jul 2014 09:33:34 GMT

join and keep or both giving same result. only difference is join gives product table keep maintain the relationship tables are same? what scenario we have to use join and keep? advantages of using join and disadvantages?

pls tell me

Re: join and keep or both giving same result. only difference is join gives product table keep maintain the relationship tables are same? what scenario we have to use join and keep? advantages of using join and disadvantages?

ThornOfCrowns — Tue, 08 Jul 2014 09:35:53 GMT

1) Please put your question in the body, rather than the title.

2) What has your research told you about JOIN and KEEP?

Re: join and keep or both giving same result. only difference is join gives product table keep maintain the relationship tables are same? what scenario we have to use join and keep? advantages of using join and disadvantages?

Tue, 08 Jul 2014 09:40:00 GMT

Hi Manoj,

Just create two sample tables, and perform Join and Keep operations, then u will get some idea.

Tell me one thing, are u working somewhere or searching for a job.

Re: join and keep or both giving same result. only difference is join gives product table keep maintain the relationship tables are same? what scenario we have to use join and keep? advantages of using join and disadvantages?

Tue, 08 Jul 2014 09:45:13 GMT

deniki brother

Re: Re: join and keep or both giving same result. only difference is join gives product table keep maintain the relationship tables are same? what scenario we have to use join and keep? advantages of using join and disadvantages?

avinashelite — Tue, 08 Jul 2014 09:49:19 GMT

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

Re: join and keep or both giving same result. only difference is join gives product table keep maintain the relationship tables are same? what scenario we have to use join and keep? advantages of using join and disadvantages?

Sat, 25 Oct 2014 10:25:52 GMT

join and keep do the similiar activities but join merges the two tables and shown as a single table in table viewer.but keep shows as 2 tables in table viewer.

Re: Re: join and keep or both giving same result. only difference is join gives product table keep m

cspindley — Sat, 02 Nov 2019 12:56:01 GMT

if your wrote the pdf then thanks, you are a gent, if not then please pass on my thanks