Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone.
I have a question about the relationship between tables.
I have uploaded two tables:
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;)
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)
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.
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)
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