Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Not applicable

Difference between keep and joins with example

please help me with the difference between keep and join with example. and also about when to use keep/join..

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: Difference between keep and joins with example

thanks to Enmanuel Santana (qlikview en espanol)

keep.jpg

join.png

View solution in original post

13 Replies
VishalWaghole
Valued Contributor II

Re: Difference between keep and joins with example

Hi mandar,


1. Join – Join will merge tables into single table.

2. Keep – if we use keep word instead of join then it will make both tables as separate at the database


-- Regards,

Vishal Waghole

VishalWaghole
Valued Contributor II

Re: Difference between keep and joins with example

Hi mandar,

for example please, have look at this thread.

Differenc b/w keep & join?

Hope you find solution thr.

-- Regards,

Vishal Waghole

Highlighted
MVP
MVP

Re: Difference between keep and joins with example

thanks to Enmanuel Santana (qlikview en espanol)

keep.jpg

join.png

View solution in original post

Not applicable

Re: Difference between keep and joins with example

Brilliant! Thanks for this share.

Not applicable

Re: Difference between keep and joins with example

Thanks Nice one

Not applicable

Re: Difference between keep and joins with example

Thank you

beck_bakytbek
Honored Contributor

Re: Difference between keep and joins with example

very cool explaine and very cool illustrated

mastankomatla21
New Contributor II

Re: Difference between keep and joins with example

Hi Massimo,

Thanks for your great explanation.

Regards,

Masthanaiah.K

+91-7306921278

samuelandlopes
Contributor

Re: Difference between keep and joins with example

Helped a lot. Tks!!!!