Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone.
I have not a precise question, I just wanted to have some clarifications about how Qlik Sense works.
I have used several Business Intelligence apps but a "many to many" relationship has always been impossible to do because atleast one table mustn't have duplicated values.
This is the case I am working on:
I have not used a custom script and account_id presents duplicated values both in transactions and users.
How does Qlik Sense works in this case?
Does it performs something like a full outer join between Transactions and Users, and an inner join between this table and User Details?
The relations between all the tables are full outer join.
The relations between all the tables are full outer join.
Ah.
Now I understand why I can't find two "id" columns and two "account_id".
Many thanks.
I guess it's always best practice to use a custom loading script therefore...