To combine the two tables that contain data about books in a library and ensure that all the data is

retained, you should use a full outer join. A full outer join is a type of join that returns all rows from

both tables, regardless of whether there is a match or not. If there is no match, null values are filled

in for the missing fields.

To perform a full outer join, you need to do the following steps:

Connect to both tables as your data sources in Tableau. You can use either live or extract connections.

Drag one table to the canvas and drop it on top of another table. This will create a join between them

based on a common field.

Click on the join icon between the tables and select Full Outer Join from the drop-down list. This will

change the join type to full outer join and show all rows from both tables.

Optionally, you can add or remove join clauses by clicking on Add or Remove buttons next to each

clause. You can also change or rename fields by clicking on them.

The other types of joins are not correct for this scenario. An inner join returns only the rows that

have a match in both tables, which will exclude any books that are missing from either table. A left

join returns all rows from the left table and only the matching rows from the right table, which will

exclude any books that are only in the right table. A right join returns all rows from the right table

and only the matching rows from the left table, which will exclude any books that are only in the left

table. Reference: https://help.tableau.com/current/pro/desktop/en-us/joining_tables.htm

https://help.tableau.com/current/pro/desktop/en-us/join_types.htm