Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Left keep & Left Right Function

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.

6 Replies
Not applicable

Re: Left keep & Left Right Function

Hi,

Please go through the link:

Understanding Join, Keep and Concatenate

Regards,

Jemimah

MVP
MVP

Re: Left keep & Left Right Function

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?

Not applicable

Re: Left keep & Left Right Function

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.

11124204_679418482159623_552466764_n.jpg

Highlighted
Not applicable

Re: Left keep & Left Right Function

Thanks for giving your valuable time.

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

Not applicable

Re: Left keep & Left Right Function

Data modeling.....for Schema designing

Not applicable

Re: Left keep & Left Right Function

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.

Community Browser