Inner Join In QlikView Applications

Introduction

The inner join in a QlikView application is automatic. The inner join is that common field names between two tables. The inner join can be used to select all rows from both tables if there is a match between the columns in both tables.

The following are the uses of Inner Joins in a QlikView Application:

• The inner join can be used to create a new result table by combining two tables based upon the join-predicate.
• There is no field in common that will render a Cartesian product.
• If the user does not specify the table name when joining then QlikView considers the previously loaded logical table.
• In QlikView, the inner join will always keep the first table name and ignores the second table name.

How an Inner Join works In QlikView Applications

The following is the basic procedure for using an Inner Join.

Step 1: Open the QlikView Application: In the first step we need to open the QlikView and go to File-> New. This window will then be opened.



Step 2: Open Edit Script Window: The next step is we to open the edit script window from File-> Edit Script. This window will then be opened.



Step 3: Open the table files: The next step is to open the table files and open our Excel file and click on the Open button.

Step 4: Open File Wizard Type: After opening the Excel file the file wizard type window will be opened; click on the "Next" button.

Step 5: Open File Wizard Transform: After the file wizard type window this window will be opened and click on the "Next" button.



Step 6: Open File Wizard Options: After the file wizard type window this window will be opened and click on the Finish button.



Step 7: Write code in Edit Script and Reload it: The next step is write the code in the edit script and reload it.



Step 8: After reloading the edit script this window will be opened and click on the OK button.



Step 9: Save the file: The next step is to save our QlikView file with the extension .qvw and click on the Save button.



Step 10: Sheet Property Window: After saving the file the next step is to select the field from the sheet property window and click on the OK button.



Step 11: Main Window: This window will show the table of an Excel sheet that you have imported into the table files.



Then again, following this process we need to import the second Excel file and write this code in the edit script and reload it.




Step 12: Sheet Property Window: After saving the file the next step is to select a field from the sheet property window and click on the OK button.

Step 13: Main Window: This window will show the table of the Excel sheet that you have imported into the table files.




Step 14: Code of Inner Join: Now again we open the edit script and write the code of the inner join and reload it.




Step 15 : Sheet Property Window: After saving the file the next step is to select a field from the sheet property window and click on the OK button.

Step 16: Final Window: This window will show the final window of the inner join.




Step 17: Table viewer: After clicking on the table viewer it opens the table view of the inner join.



Then, the following is the final window.




 So this final window will show the common field between two tables.

Summary

This article describes how inner joins work in QlikView applications.