topic Re: Mother daughter in QlikView https://community.qlik.com/t5/QlikView/Mother-daughter/m-p/460579#M695306 <HTML><HEAD></HEAD><BODY><P>Would it help:</P><P></P><P>[prime table]:</P><P>LOAD Mother,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Daugter</P><P>Resident [some table];</P><P></P><P>concatenate (prime table)</P><P>LOAD Distinct Mother,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Mother as Daughter</P><P>Resident [prime table]</P></BODY></HTML> Tue, 11 Jun 2013 12:56:46 GMT 2013-06-11T12:56:46Z Mother daughter https://community.qlik.com/t5/QlikView/Mother-daughter/m-p/460578#M695305 <HTML><HEAD></HEAD><BODY><DIV>Hi all,</DIV><DIV> </DIV><DIV>The following table i have made:</DIV><DIV> </DIV><DIV><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Mother</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Daughter</STRONG></SPAN></TH></TR><TR><TD>1</TD><TD>2</TD></TR><TR><TD>1</TD><TD>3</TD></TR><TR><TD>1</TD><TD>4</TD></TR><TR><TD>1</TD><TD>5</TD></TR></TBODY></TABLE></DIV><DIV> </DIV><DIV>My result must be (mother en daughter must be the same in the same table)</DIV><DIV> </DIV><DIV><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Mother</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Daugther</STRONG></SPAN></TH></TR><TR><TD>1</TD><TD>2</TD></TR><TR><TD>1</TD><TD>3</TD></TR><TR><TD>1</TD><TD>4</TD></TR><TR><TD>1</TD><TD>5</TD></TR><TR><TD style="background-color: rgb(226, 218, 29);"><STRONG>1</STRONG></TD><TD style="background-color: rgb(215, 219, 35);"><STRONG>1</STRONG></TD></TR></TBODY></TABLE></DIV><DIV> </DIV><DIV>But how?</DIV><DIV> </DIV><DIV>Best regards,</DIV><DIV>Arjan</DIV></BODY></HTML> Tue, 11 Jun 2013 12:42:31 GMT https://community.qlik.com/t5/QlikView/Mother-daughter/m-p/460578#M695305 Anonymous 2013-06-11T12:42:31Z Re: Mother daughter https://community.qlik.com/t5/QlikView/Mother-daughter/m-p/460579#M695306 <HTML><HEAD></HEAD><BODY><P>Would it help:</P><P></P><P>[prime table]:</P><P>LOAD Mother,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Daugter</P><P>Resident [some table];</P><P></P><P>concatenate (prime table)</P><P>LOAD Distinct Mother,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Mother as Daughter</P><P>Resident [prime table]</P></BODY></HTML> Tue, 11 Jun 2013 12:56:46 GMT https://community.qlik.com/t5/QlikView/Mother-daughter/m-p/460579#M695306 2013-06-11T12:56:46Z Re: Mother daughter https://community.qlik.com/t5/QlikView/Mother-daughter/m-p/460580#M695307 <HTML><HEAD></HEAD><BODY><P>Thanks!!!</P><P></P><P>Regards,</P><P>Arjan</P></BODY></HTML> Tue, 11 Jun 2013 12:59:51 GMT https://community.qlik.com/t5/QlikView/Mother-daughter/m-p/460580#M695307 Anonymous 2013-06-11T12:59:51Z