Left keep & Left Right Function

[#1]

Hi Experts,

Left keep & Left Right functions are new to me, I just know that these two functions are used in scripting. And Removes uneccessry records say null ..But what they actually do ?

What is the purpose of using these functions in scripting??

Please explain me in detail And if i wrong make me correct.

Thanks in advance.

[#2]

Hi,

Please go through the link:

Understanding Join, Keep and Concatenate

Regards,

Jemimah

[tresesco]

Have a look at the online help, it explains with example. Then you might check discussions like : Uses for Left Join and Concatenate in tables?

[#4]

Hi,Kojol

Both are used for same purpose ,But

Left join:When u use this join between two tables the join occurs but the rows from the left table taken and from right table only matching rows.

Left keep:same as join ,but keeps the table separate in table viewer.

[#5]

Thanks for giving your valuable time.

But in which type of scenarios we should use left keep or right keep function instead of join?

[#6]

Data modeling.....for Schema designing

[#7]

Hi,Kajol pal

If this has answered your question can you please close this thread by marking one of the answers correct? It will help others find a (correct) answer to similar problems and lets other contributing members know that this requires no more attention.