Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Change Full Outer Join to Inner Join

Hello everyone.

I have a question about the relationship between tables.

I have uploaded two tables:

Screenshot_2.png

and the relationship between these two tables should be "Full Outer Join", right?
My question is: is it possible to change this relationship to inner join?

I know I can join these two tables in the script but I'd prefere to keep the tables divided

(i joined them with this script:

[JoinedTable]:

SQL SELECT "id",

     .......

FROM XYZ.UserDetails;

INNER JOIN

SQL SELECT "id",

    "account_id",

    ...

FROM XYZ.Users;)

1 Solution

Accepted Solutions
dwforest
Specialist II
Specialist II

no, you cannot specify the inner/outer-ness of the logical connection between tables in your data model.

What is the end goal?

You may be able to "filter" out rows by looking at missing values in the other table.

if([user detail].somefield is null,'',[user id].datapoint)

View solution in original post

3 Replies
Gysbert_Wassenaar

and the relationship between these two tables should be "Full Outer Join", right?

Joins are used to join tables so the result is one table. A Full Outer Join is not a relationship but an operation.

My question is: is it possible to change this relationship to inner join?

An inner join is also an operation, not a relation.

I know I can join these two tables in the script but I'd prefere to keep the tables divided

Then load the tables separately and don't join them.


talk is cheap, supply exceeds demand
dwforest
Specialist II
Specialist II

no, you cannot specify the inner/outer-ness of the logical connection between tables in your data model.

What is the end goal?

You may be able to "filter" out rows by looking at missing values in the other table.

if([user detail].somefield is null,'',[user id].datapoint)

pstiglich
Contributor II
Contributor II

It would be nice to be able to specify an inner join in the data model - e.g., I have a fact table with only a few dates currently such as sale date - but in my date dimension (we use a database table to store our fiscal calendar) we store all dates as a row in the table - 1 row per date, for about 20 years.  In a sheet, I always have to filter out the dates not tied to a sale date.  This confuses the users e.g., they can choose one of the 20X365 date keys which are not tied to a sale fact and then they don't see anything.  

They should only be able to see dates from the date dim for which a date key has been used in the fact record. 

Pete