Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
wairimujulius
Contributor II
Contributor II

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

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.

2 Replies
tresesco
MVP
MVP

You can do that using Outer Join 

wairimujulius
Contributor II
Contributor II
Author

Hello,

I still lost the rows that in the joining table