The join and keep prefixes can be preceded by the prefix inner.If used before join it specifies that an inner join should be used. The resulting table will thus only contain combinations of field values from the raw data tables where the linking field values are represented in both tables. If used before keep, it specifies that both raw data tables should be reduced to their common intersection before being stored in Qlik Sense.
Inner ( Join | Keep) [ (tablename) ](loadstatement |selectstatement )
|tablename||The named table to be compared to the loaded table.|
|loadstatement or selectstatement||The LOAD or SELECT statement for the loaded table.|
Add the example script to your app and run it. Then add the fields listed in the results column to a sheet in your app to see the result.
Table1: Load * inline [ Column1, Column2 A, B 1, aa 2, cc 3, ee ]; Table2: Inner Join Load * inline [ Column1, Column3 A, C 1, xx 4, yy ];
For more information about using inline loads, see Inline loads.
This example demonstrates the Inner Join output where only values present in both the first (left) and the second (right) tables are joined.