topic Re: KEEP and JOIN in QlikView

KEEP and JOIN

lionking15 — Wed, 25 Nov 2020 16:16:04 GMT

Hii,

I want to know difference between keep and join means which is better??and why??

and the scenario when to use which one??

thanks!!!!

Re: KEEP and JOIN

Chanty4u — Tue, 09 Aug 2016 07:37:31 GMT

chk dis

When Use Keep When Use Join

Re: KEEP and JOIN

Anonymous — Tue, 09 Aug 2016 07:41:51 GMT

Hi Giridhar,

With Join you will join two tables in one table, and with keep you will get two tables, reducing data.

Regards!

Re: KEEP and JOIN

Tue, 09 Aug 2016 07:44:46 GMT

Hi,

Join: Merging the records of the two tables as one table. in the QV memory side you will get Only one table

Keep: works same as JOIN but at QV memory side you will get both tables , means using keep we can remain the both tables for other pursose.

Thanks

-Abdul

Re: KEEP and JOIN

avinashelite — Tue, 09 Aug 2016 07:47:34 GMT

check this too

Difference between keep and joins with example

Re: KEEP and JOIN

maxgro — Tue, 09 Aug 2016 08:01:25 GMT

there is no better

this is a good doc with the difference between keep and join

Understanding Join, Keep and Concatenate

Re: Difference between keep and joins with example

Re: KEEP and JOIN

beck_bakytbek — Tue, 09 Aug 2016 08:18:07 GMT

Hi GIRIDHAR,

you can create this example within of your script and then you can use Join and Keep, on that demonstrative base you will see the difference between Join and Keep

Table1:

Load * Inline [

FieldA, FieldB. FieldC

1, A, 1A,

2, B, 2B,

3, C, 3C

];

Join (Table1)

Load * Inline [

FieldA, FieldD. FieldE

2, X, 2X,

3, Y, 3Y,

4, Z, 4Z

];

then you will have a single table, i am sure if you create this example, you Problem will be automatically solved.

Learning by Doing

i hope that helps

beck

Re: KEEP and JOIN

ecolomer — Tue, 06 Sep 2016 05:31:54 GMT

See this doc's