What does an Inner Join retain in its result?

An Inner Join retains only those rows that have matching values in both tables being joined. When performing an Inner Join, Qlik Sense evaluates the specified columns in each table; if a row in one table has a corresponding row in the other table with the same value, that row is included in the result set. This means that the final output will only consist of rows where a relationship exists between the two datasets based on the join condition.

This is a fundamental concept in relational databases and data manipulation, as Inner Joins help to filter data down to only the relevant records that share commonality, effectively excluding any records that do not have matches in both tables. This feature is often utilized to maintain data integrity and relevance in analyses, ensuring that only meaningful data interactions are examined.