How to Join Two Tables Without Loosing Rows in Either of the tables

[wairimujulius]

Hello Qlik Sense Users,

I am joining two tables using a Common field (Policy Holder ID), but am loosing huge number of records in the second table which am joining with.

Please assist if there is any way I could join without loosing any rows from either tables.

Thank you.

[tresB]

You can do that using Outer Join 

[wairimujulius]

Hello,

I still lost the rows that in the joining table