Join/outer join

When you want to get the data from both the tables you use the Join keyword. When you just use only Join between two tables, it is always a full outer join. The Outer keyword is optional. The following diagram shows the Venn diagram for the outer join:

Now, let's see how we script this joining condition in Qlik Sense:

1. Create a new Qlik Sense application. Give it a name of your choice.
2. Jump to Script editor, create a new tab, and rename it as Outer Join, as shown in following screenshot. Write the script shown in the following screenshot:

1. Once you write the script, click on Load Data to run the script and load the data.
2. Once the data is loaded, create a new sheet and add the Table object to see the joined table data, as shown in the following screenshot:

As output of Outer Join, we got five fields, as shown in the preceding screenshot. You can also observe that the last two rows have null values for the fields, which come from the Order table, where the customers 4 and 5 are not present.