https://community.qlik.com/t5/Connectivity-Data-Prep/How-to-Join-Two-Tables-Without-Loosing-Rows-in-Either-of-the/m-p/1702959#M5167 <P>Hello,</P><P>I still lost the rows that in the joining table</P> Mon, 18 May 2020 07:51:43 GMT wairimujulius 2020-05-18T07:51:43Z https://community.qlik.com/t5/Connectivity-Data-Prep/How-to-Join-Two-Tables-Without-Loosing-Rows-in-Either-of-the/m-p/1702929#M5164 <P>Hello Qlik Sense Users,</P><P>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.</P><P>Please assist if there is any way I could join without loosing any rows from either tables.</P><P>Thank you.</P> Mon, 18 May 2020 05:46:04 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/How-to-Join-Two-Tables-Without-Loosing-Rows-in-Either-of-the/m-p/1702929#M5164 wairimujulius 2020-05-18T05:46:04Z https://community.qlik.com/t5/Connectivity-Data-Prep/How-to-Join-Two-Tables-Without-Loosing-Rows-in-Either-of-the/m-p/1702936#M5165 <P>You can do that using <A href="https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptPrefixes/Outer.htm" target="_self">Outer Join</A>&nbsp;</P> Mon, 18 May 2020 06:14:22 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/How-to-Join-Two-Tables-Without-Loosing-Rows-in-Either-of-the/m-p/1702936#M5165 tresB 2020-05-18T06:14:22Z https://community.qlik.com/t5/Connectivity-Data-Prep/How-to-Join-Two-Tables-Without-Loosing-Rows-in-Either-of-the/m-p/1702959#M5167 <P>Hello,</P><P>I still lost the rows that in the joining table</P> Mon, 18 May 2020 07:51:43 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/How-to-Join-Two-Tables-Without-Loosing-Rows-in-Either-of-the/m-p/1702959#M5167 wairimujulius 2020-05-18T07:51:43Z