topic joins and keep in QlikView

joins and keep

ramesh1234 — Wed, 25 Nov 2020 16:16:04 GMT

Differnce between joins and keep ( I am Qlikview learner)

Re: joins and keep

tresB — Mon, 11 Dec 2017 09:26:27 GMT

Lots of threads might be available already here about what you want to know. Therefore, it's better to search before you create a kind-of duplicate threads. Here are few you might want to go through :

Re: Join vs Keep ‌

Understanding Join, Keep and Concatenate

Re: joins and keep

devarasu07 — Mon, 11 Dec 2017 09:31:25 GMT

Hi,

let say you have tableA, & B then if u use join this join and return into one final output table whereas keep implement join logic on two tables and maintains two tables separately.

for more check this thread

Understanding Join, Keep and Concatenate

Difference between keep and joins with example | Qlik Community

Re: joins and keep

Anil_Babu_Samineni — Mon, 11 Dec 2017 09:33:39 GMT

Welcome to Qlik world !!!

I would suggest do some work by hand to understand better clear rather functional. And, Start using Google / Bing as it is free. we can use that then come back to the community..

Re: joins and keep

sangland2 — Fri, 22 Dec 2017 03:45:28 GMT

I'm not new to QV but there has been a change to joins between QV10 and QV12 that I'd also like to understand, and might also help rakesh.

In QV10 the following script returns a single table of calendar years:

Calendars:

Load

name as CalendarName,

oid as myCalendar ;

SQL SELECT name,oid FROM Calendar ;

left join

Load myCalendar,

description as CalendarYear;

SQL SELECT myCalendar,description FROM CalendarYear;

In QV12 the same query returns just one row:

To get the same result in QV12 as QV10 I have to separate the two tables explicitly:

Calendars:

Load

name as CalendarName,

oid as myCalendar ;

SQL SELECT name,oid FROM Calendar ;

CalendarYear:

Load myCalendar,

description as CalendarYear;

SQL SELECT myCalendar,description FROM CalendarYear;

Using "left keep join" does still results in a single table but only one value as the Calendar Name ??

Using right keep is also works in QV12, but changing all my left joins to right keep joins to upgrade to QV12 doesn't make any sense ?

Do the QV12 release notes cover this difference?

Re: joins and keep

Anil_Babu_Samineni — Fri, 22 Dec 2017 05:12:43 GMT

Oh is it? I never used QV10 in my history. So, I don't know..!