KEEP and JOIN

[lionking15]

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

[Chanty4u]

Hi

chk dis

When Use Keep When Use Join

[Anonymous]

Hi Giridhar,

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

Regards!

[#4]

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

[avinashelite]

check this too

Difference between keep and joins with example

[maxgro]

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

[beck_bakytbek]

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

[ecolomer]

See this doc's