Discussion Board for collaboration related to Creating Analytics for QlikView.
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.
Please go through the link:
Understanding Join, Keep and Concatenate
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?
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.
Thanks for giving your valuable time.
But in which type of scenarios we should use left keep or right keep function instead of join?
Data modeling.....for Schema designing
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.