topic Re: Combine two tables in QlikView https://community.qlik.com/t5/QlikView/Combine-two-tables/m-p/63513#M781790 <HTML><HEAD></HEAD><BODY><P>i see <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px; background-color: #f2f2f2;">CombDate is common between them</SPAN></P></BODY></HTML> Thu, 22 Mar 2018 13:01:12 GMT ychaitanya 2018-03-22T13:01:12Z Combine two tables https://community.qlik.com/t5/QlikView/Combine-two-tables/m-p/63508#M781785 <HTML><HEAD></HEAD><BODY><P>Dear Gurus </P><P></P><P>I have following data </P><P></P><P>[Visit]:</P><P>LOAD * INLINE [</P><P>&nbsp;&nbsp;&nbsp; RepCode, VisitDate, PlanDate, CombDate</P><P>&nbsp;&nbsp;&nbsp; 0928, 01.03.2018, , 01.03.2018</P><P>&nbsp;&nbsp;&nbsp; 0928, , 02.03.2018, 02.03.2018</P><P>&nbsp;&nbsp;&nbsp; 0928, 03.01.2018, 03.03.2018, 03.03.2018</P><P>&nbsp;&nbsp;&nbsp; 0428, 01.03.2018, , 01.03.2018</P><P>&nbsp;&nbsp;&nbsp; 0428, , 02.03.2018, 02.03.2018</P><P>&nbsp;&nbsp;&nbsp; 0428, 03.01.2018, 03.03.2018, 03.03.2018</P><P>&nbsp;&nbsp;&nbsp; 0933, 01.03.2018, , 01.03.2018</P><P>&nbsp;&nbsp;&nbsp; 0933, , 02.03.2018, 02.03.2018</P><P>&nbsp;&nbsp;&nbsp; 0933, 03.01.2018, 03.03.2018, 03.03.2018</P><P>];</P><P></P><P>[Calendar]:</P><P>LOAD * INLINE [</P><P>&nbsp;&nbsp;&nbsp; CalDate</P><P>&nbsp;&nbsp;&nbsp; 01.03.2018</P><P>&nbsp;&nbsp;&nbsp; 02.03.2018</P><P>&nbsp;&nbsp;&nbsp; 03.03.2018</P><P>&nbsp;&nbsp;&nbsp; 04.03.2018</P><P>];</P><P> and with this data i want&nbsp; a new table with records like followings </P><P>[Main]:</P><P>LOAD * INLINE [</P><P>&nbsp;&nbsp;&nbsp; RepCode, VisitDate1, PlanDate1, CombDate1</P><P>&nbsp;&nbsp;&nbsp; 0428, 01.03.2018, , 01.03.2018</P><P>&nbsp;&nbsp;&nbsp; 0428, , 02.03.2018, 02.03.2018</P><P>&nbsp;&nbsp;&nbsp; 0428, 03.01.2018, 03.03.2018, 03.03.2018</P><P>&nbsp;&nbsp;&nbsp; 0428, , , 04.03.2018</P><P>&nbsp;&nbsp;&nbsp; 0933, 01.03.2018, , 01.03.2018</P><P>&nbsp;&nbsp;&nbsp; 0933, , 02.03.2018, 02.03.2018</P><P>&nbsp;&nbsp;&nbsp; 0933, 03.01.2018, 03.03.2018, 03.03.2018</P><P>&nbsp;&nbsp;&nbsp; 0933, , , 04.03.2018</P><P>&nbsp;&nbsp;&nbsp; 0928, 01.03.2018, , 01.03.2018</P><P>&nbsp;&nbsp;&nbsp; 0928, , 02.03.2018, 02.03.2018</P><P>&nbsp;&nbsp;&nbsp; 0928, 03.01.2018, 03.03.2018, 03.03.2018</P><P>&nbsp;&nbsp;&nbsp; 0928, , , 04.03.2018</P><P>];</P><P></P><P></P><P>How to make a product of above two tables</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Combine-two-tables/m-p/63508#M781785 Anonymous 2020-11-25T16:16:04Z Re: Combine two tables https://community.qlik.com/t5/QlikView/Combine-two-tables/m-p/63509#M781786 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">[Visit]:</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">LOAD * INLINE [</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp; RepCode, VisitDate, PlanDate, CombDate</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp; 0928, 01.03.2018, , 01.03.2018</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp; 0928, , 02.03.2018, 02.03.2018</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp; 0928, 03.01.2018, 03.03.2018, 03.03.2018</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp; 0428, 01.03.2018, , 01.03.2018</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp; 0428, , 02.03.2018, 02.03.2018</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp; 0428, 03.01.2018, 03.03.2018, 03.03.2018</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp; 0933, 01.03.2018, , 01.03.2018</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp; 0933, , 02.03.2018, 02.03.2018</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp; 0933, 03.01.2018, 03.03.2018, 03.03.2018</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">];</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Join(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Visit)</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">[Calendar]:</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">LOAD * INLINE [</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp; <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">CombDate</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp; 01.03.2018</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp; 02.03.2018</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp; 03.03.2018</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp; 04.03.2018</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">];</P></BODY></HTML> Wed, 21 Mar 2018 17:59:06 GMT https://community.qlik.com/t5/QlikView/Combine-two-tables/m-p/63509#M781786 ychaitanya 2018-03-21T17:59:06Z Re: Combine two tables https://community.qlik.com/t5/QlikView/Combine-two-tables/m-p/63510#M781787 <HTML><HEAD></HEAD><BODY><P>Thanks for the reply,</P><P></P><P>i got the following result by joining the</P><P>&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="width: 282px;"><TBODY><TR><TD class="xl63" height="18" width="73">CombDate</TD><TD class="xl63" width="62">PlanDate</TD><TD class="xl63" width="55">RepCode</TD><TD class="xl63" width="62">VisitDate</TD></TR><TR><TD class="xl64" height="18">01.03.2018</TD><TD class="xl65"> </TD><TD class="xl64">0428</TD><TD class="xl64">01.03.2018</TD></TR><TR><TD class="xl64" height="18">01.03.2018</TD><TD class="xl65"> </TD><TD class="xl64">0928</TD><TD class="xl64">01.03.2018</TD></TR><TR><TD class="xl64" height="18">01.03.2018</TD><TD class="xl65"> </TD><TD class="xl64">0933</TD><TD class="xl64">01.03.2018</TD></TR><TR><TD class="xl64" height="18">02.03.2018</TD><TD class="xl64">02.03.2018</TD><TD class="xl64">0428</TD><TD class="xl65"> </TD></TR><TR><TD class="xl64" height="18">02.03.2018</TD><TD class="xl64">02.03.2018</TD><TD class="xl64">0928</TD><TD class="xl65"> </TD></TR><TR><TD class="xl64" height="18">02.03.2018</TD><TD class="xl64">02.03.2018</TD><TD class="xl64">0933</TD><TD class="xl65"> </TD></TR><TR><TD class="xl64" height="18">03.03.2018</TD><TD class="xl64">03.03.2018</TD><TD class="xl64">0428</TD><TD class="xl64">03.01.2018</TD></TR><TR><TD class="xl64" height="18">03.03.2018</TD><TD class="xl64">03.03.2018</TD><TD class="xl64">0928</TD><TD class="xl64">03.01.2018</TD></TR><TR><TD class="xl64" height="18">03.03.2018</TD><TD class="xl64">03.03.2018</TD><TD class="xl64">0933</TD><TD class="xl64">03.01.2018</TD></TR><TR><TD class="xl66" height="18">04.03.2018</TD><TD class="xl67"> </TD><TD class="xl67"> </TD><TD class="xl67"> </TD></TR></TBODY></TABLE><P></P><P></P><P>but how to get 04.03.2018 with all repcodes with plandate and visitdate blank</P><P>ie</P><P>&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 252px;"><TBODY><TR><TD class="xl65" height="18" width="73">CombDate</TD><TD class="xl65" style="border-left: none;" width="62">PlanDate</TD><TD class="xl65" style="border-left: none;" width="55">RepCode</TD><TD class="xl65" style="border-left: none;" width="62">VisitDate</TD></TR><TR><TD class="xl66" height="18" style="border-top: none;">01.03.2018</TD><TD class="xl67" style="border-top: none; border-left: none;"> </TD><TD class="xl66" style="border-top: none; border-left: none;">0428</TD><TD class="xl66" style="border-top: none; border-left: none;">01.03.2018</TD></TR><TR><TD class="xl66" height="18" style="border-top: none;">01.03.2018</TD><TD class="xl67" style="border-top: none; border-left: none;"> </TD><TD class="xl66" style="border-top: none; border-left: none;">0928</TD><TD class="xl66" style="border-top: none; border-left: none;">01.03.2018</TD></TR><TR><TD class="xl66" height="18" style="border-top: none;">01.03.2018</TD><TD class="xl67" style="border-top: none; border-left: none;"> </TD><TD class="xl66" style="border-top: none; border-left: none;">0928</TD><TD class="xl66" style="border-top: none; border-left: none;">01.03.2018</TD></TR><TR><TD class="xl66" height="18" style="border-top: none;">02.03.2018</TD><TD class="xl66" style="border-top: none; border-left: none;">02.03.2018</TD><TD class="xl66" style="border-top: none; border-left: none;">0428</TD><TD class="xl67" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl66" height="18" style="border-top: none;">02.03.2018</TD><TD class="xl66" style="border-top: none; border-left: none;">02.03.2018</TD><TD class="xl66" style="border-top: none; border-left: none;">0928</TD><TD class="xl67" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl66" height="18" style="border-top: none;">02.03.2018</TD><TD class="xl66" style="border-top: none; border-left: none;">02.03.2018</TD><TD class="xl66" style="border-top: none; border-left: none;">0933</TD><TD class="xl67" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl66" height="18" style="border-top: none;">03.03.2018</TD><TD class="xl66" style="border-top: none; border-left: none;">03.03.2018</TD><TD class="xl66" style="border-top: none; border-left: none;">0428</TD><TD class="xl66" style="border-top: none; border-left: none;">03.01.2018</TD></TR><TR><TD class="xl66" height="18" style="border-top: none;">03.03.2018</TD><TD class="xl66" style="border-top: none; border-left: none;">03.03.2018</TD><TD class="xl66" style="border-top: none; border-left: none;">0928</TD><TD class="xl66" style="border-top: none; border-left: none;">03.01.2018</TD></TR><TR><TD class="xl66" height="18" style="border-top: none;">03.03.2018</TD><TD class="xl66" style="border-top: none; border-left: none;">03.03.2018</TD><TD class="xl66" style="border-top: none; border-left: none;">0933</TD><TD class="xl66" style="border-top: none; border-left: none;">03.01.2018</TD></TR><TR><TD class="xl68" height="18" style="border-top: none;">04.03.2018</TD><TD class="xl69" style="border-top: none; border-left: none;"> </TD><TD class="xl66" style="border-top: none; border-left: none;">0428</TD><TD class="xl69" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl68" height="18" style="border-top: none;">04.03.2018</TD><TD class="xl69" style="border-top: none; border-left: none;"> </TD><TD class="xl66" style="border-top: none; border-left: none;">0928</TD><TD class="xl69" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl68" height="18" style="border-top: none;">04.03.2018</TD><TD class="xl69" style="border-top: none; border-left: none;"> </TD><TD class="xl66" style="border-top: none; border-left: none;">0933</TD><TD class="xl69" style="border-top: none; border-left: none;"> </TD></TR></TBODY></TABLE><P></P><P>Thanks</P></BODY></HTML> Thu, 22 Mar 2018 07:19:38 GMT https://community.qlik.com/t5/QlikView/Combine-two-tables/m-p/63510#M781787 Anonymous 2018-03-22T07:19:38Z Re: Combine two tables https://community.qlik.com/t5/QlikView/Combine-two-tables/m-p/63511#M781788 <HTML><HEAD></HEAD><BODY><P>Which field is common in both the tables?</P><P>Do you want cartesian join?</P></BODY></HTML> Thu, 22 Mar 2018 10:39:20 GMT https://community.qlik.com/t5/QlikView/Combine-two-tables/m-p/63511#M781788 shiveshsingh 2018-03-22T10:39:20Z Re: Combine two tables https://community.qlik.com/t5/QlikView/Combine-two-tables/m-p/63512#M781789 <HTML><HEAD></HEAD><BODY><P>yes a cartesian join. for every RepCode vs CombDate</P></BODY></HTML> Thu, 22 Mar 2018 12:24:21 GMT https://community.qlik.com/t5/QlikView/Combine-two-tables/m-p/63512#M781789 Anonymous 2018-03-22T12:24:21Z Re: Combine two tables https://community.qlik.com/t5/QlikView/Combine-two-tables/m-p/63513#M781790 <HTML><HEAD></HEAD><BODY><P>i see <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px; background-color: #f2f2f2;">CombDate is common between them</SPAN></P></BODY></HTML> Thu, 22 Mar 2018 13:01:12 GMT https://community.qlik.com/t5/QlikView/Combine-two-tables/m-p/63513#M781790 ychaitanya 2018-03-22T13:01:12Z Re: Combine two tables https://community.qlik.com/t5/QlikView/Combine-two-tables/m-p/63514#M781791 <HTML><HEAD></HEAD><BODY><P>Then he can probably outer join the tables</P></BODY></HTML> Thu, 22 Mar 2018 15:30:26 GMT https://community.qlik.com/t5/QlikView/Combine-two-tables/m-p/63514#M781791 shiveshsingh 2018-03-22T15:30:26Z