topic Re: duplicate rows when joining in QlikView https://community.qlik.com/t5/QlikView/duplicate-rows-when-joining/m-p/447783#M167123 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I suggest you post the portion of your script that results in the output you are showing. </P><P></P><P>Regards</P><P>Jonathan</P></BODY></HTML> Wed, 24 Oct 2012 10:43:07 GMT jonathandienst 2012-10-24T10:43:07Z duplicate rows when joining https://community.qlik.com/t5/QlikView/duplicate-rows-when-joining/m-p/447782#M167122 <HTML><HEAD></HEAD><BODY><P style="background-color: #ffffff; color: #737373; font-family: Arial;">Hi guys,</P><P></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;">I have two tables whrere am outer joining one with the other but the problem is it is giving a result like below where if a person belows to External it duplicates the record with an empty on but if they below to BSERVE then its fine</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="background-color: #ffffff; border: 1px solid #cccccc; margin: 1px 0; padding: 3px; color: #737373; font-family: Arial;" width="64"><TBODY><TR style="border: 0px;"><TD height="20" style="border: 0px solid black; margin: 1px; padding: 3px;" width="64">Source</TD></TR><TR style="border: 0px;"><TD height="20" style="border: 0px solid black; margin: 1px; padding: 3px;">BSERVE</TD></TR><TR style="border: 0px;"><TD height="20" style="border: 0px solid black; margin: 1px; padding: 3px;">INTERNAL</TD></TR></TBODY></TABLE><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="background-color: #ffffff; border: 1px solid #cccccc; margin: 1px 0; padding: 3px; color: #737373; font-family: Arial;" width="128"><TBODY><TR style="border: 0px;"><TD height="20" style="border: 0px solid black; margin: 1px; padding: 3px;" width="64">source ID</TD><TD style="border: 0px solid black; margin: 1px; padding: 3px;" width="64">ITYPE</TD></TR><TR style="border: 0px;"><TD align="right" height="20" style="border: 0px solid black; margin: 1px; padding: 3px;">22</TD><TD style="border: 0px solid black; margin: 1px; padding: 3px;">External</TD></TR><TR style="border: 0px;"><TD align="right" height="20" style="border: 0px solid black; margin: 1px; padding: 3px;">22</TD><TD style="border: 0px solid black; margin: 1px; padding: 3px;"><BR /></TD></TR><TR style="border: 0px;"><TD align="right" height="20" style="border: 0px solid black; margin: 1px; padding: 3px;">34</TD><TD style="border: 0px solid black; margin: 1px; padding: 3px;">BSERVE</TD></TR><TR style="border: 0px;"><TD align="right" height="20" style="border: 0px solid black; margin: 1px; padding: 3px;">36</TD><TD style="border: 0px solid black; margin: 1px; padding: 3px;">BSERVE</TD></TR><TR style="border: 0px;"><TD align="right" height="20" style="border: 0px solid black; margin: 1px; padding: 3px;">37</TD><TD style="border: 0px solid black; margin: 1px; padding: 3px;">External</TD></TR><TR style="border: 0px;"><TD align="right" height="20" style="border: 0px solid black; margin: 1px; padding: 3px;">37</TD><TD style="border: 0px solid black; margin: 1px; padding: 3px;"><BR /></TD></TR></TBODY></TABLE><P></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;">any ideas?</P><P></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;">thanks</P></BODY></HTML> Wed, 24 Oct 2012 10:36:49 GMT https://community.qlik.com/t5/QlikView/duplicate-rows-when-joining/m-p/447782#M167122 2012-10-24T10:36:49Z Re: duplicate rows when joining https://community.qlik.com/t5/QlikView/duplicate-rows-when-joining/m-p/447783#M167123 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I suggest you post the portion of your script that results in the output you are showing. </P><P></P><P>Regards</P><P>Jonathan</P></BODY></HTML> Wed, 24 Oct 2012 10:43:07 GMT https://community.qlik.com/t5/QlikView/duplicate-rows-when-joining/m-p/447783#M167123 jonathandienst 2012-10-24T10:43:07Z