topic Re: Opposite of Inner Join in QlikView

Opposite of Inner Join

Black_Hole — Sat, 16 Nov 2024 01:37:07 GMT

Hello All,

Please could you tell me if there is a functionality which is the opposite of INNER JOIN ?

I already tried the functionality OUTER JOIN, but the result is not as expected.

Thank you in advance for your help.

Brett_Bleess — Mon, 30 Dec 2019 18:48:01 GMT

Have a look at the following specific Design Blog post to see if it may help:

Here is the base URL for the Design Blog area as well in case you want to search further for other posts, and here is Help link on Joins after that:

Hopefully those will get you what you need.

Regards,
Brett

lorenzoconforti — Tue, 31 Dec 2019 00:01:27 GMT

Are you looking for an anti join? Both right and left?

in that case you just need to create an inner join then load back both tables with a where clause not exists

Lorenzo

Black_Hole — Tue, 14 Jan 2020 09:47:19 GMT

Many thanks for sharing the links.

For the moment I tried the solution using an inner join and then a clause Where not exists.

And this solution gives me the result expected. 👍