topic Re: A special kind of Join Tables in Discussions https://community.jmp.com/t5/Discussions/A-special-kind-of-Join-Tables/m-p/704560#M88871 <P>I am wondering whether these are errors:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="peng_liu_0-1701390830575.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/59175i33E5608970E8170B/image-size/medium?v=v2&amp;px=400" role="button" title="peng_liu_0-1701390830575.png" alt="peng_liu_0-1701390830575.png" /></span></P> <P>If they are "B"'s, sounds like you want a Cartesian join:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="peng_liu_1-1701391068500.png" style="width: 999px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/59176i0A45075B3255F409/image-size/large?v=v2&amp;px=999" role="button" title="peng_liu_1-1701391068500.png" alt="peng_liu_1-1701391068500.png" /></span></P> <P>&nbsp;</P> Fri, 01 Dec 2023 00:38:53 GMT peng_liu 2023-12-01T00:38:53Z A special kind of Join Tables https://community.jmp.com/t5/Discussions/A-special-kind-of-Join-Tables/m-p/704483#M88865 <P>Let's say, I have 2 tables. Table <FONT face="courier new,courier">dt1</FONT> has an arbitrary number of columns (<STRONG>a, b , ...</STRONG>) and table <FONT face="courier new,courier">dt2</FONT> has columns (<STRONG>x, y , ...</STRONG>).</P><P>What is the easiest way in Jmp to generate a crossed join of the two tables - such that for any row&nbsp;<STRONG>an, bn,&nbsp; ...</STRONG> from <FONT face="courier new,courier">dt1</FONT>, there are rows in the final table with <STRONG>an, bn,&nbsp; ...</STRONG>&nbsp; in combination with values <STRONG>xm,ym, ... </STRONG>from <FONT face="courier new,courier">dt2.</FONT><STRONG><BR /></STRONG></P><P>&nbsp;</P><P>&nbsp;</P><LI-SPOILER><P><STRONG>&nbsp;</STRONG></P><TABLE><TBODY><TR><TD><STRONG>a</STRONG></TD><TD><STRONG>b</STRONG></TD></TR><TR><TD>A</TD><TD>C</TD></TR><TR><TD>A</TD><TD>D</TD></TR><TR><TD>B</TD><TD>C</TD></TR><TR><TD>B</TD><TD>D</TD></TR></TBODY></TABLE><P><STRONG>&nbsp;</STRONG></P><TABLE><TBODY><TR><TD><STRONG>x</STRONG></TD><TD><STRONG>y</STRONG></TD></TR><TR><TD>1</TD><TD>1</TD></TR><TR><TD>1</TD><TD>2</TD></TR><TR><TD>2</TD><TD>1</TD></TR><TR><TD>2</TD><TD>2</TD></TR></TBODY></TABLE><P><STRONG>&nbsp;</STRONG></P><TABLE><TBODY><TR><TD><STRONG>a</STRONG></TD><TD><STRONG>b</STRONG></TD><TD><STRONG>x</STRONG></TD><TD><STRONG>y</STRONG></TD></TR><TR><TD>A</TD><TD>C</TD><TD>1</TD><TD>1</TD></TR><TR><TD>A</TD><TD>C</TD><TD>1</TD><TD>2</TD></TR><TR><TD>A</TD><TD>C</TD><TD>2</TD><TD>1</TD></TR><TR><TD>A</TD><TD>C</TD><TD>2</TD><TD>2</TD></TR><TR><TD>A</TD><TD>D</TD><TD>1</TD><TD>1</TD></TR><TR><TD>A</TD><TD>D</TD><TD>1</TD><TD>2</TD></TR><TR><TD>A</TD><TD>D</TD><TD>2</TD><TD>1</TD></TR><TR><TD>A</TD><TD>D</TD><TD>2</TD><TD>2</TD></TR><TR><TD>B</TD><TD>C</TD><TD>1</TD><TD>1</TD></TR><TR><TD>B</TD><TD>C</TD><TD>1</TD><TD>2</TD></TR><TR><TD>B</TD><TD>C</TD><TD>2</TD><TD>1</TD></TR><TR><TD>B</TD><TD>C</TD><TD>2</TD><TD>2</TD></TR><TR><TD>A</TD><TD>D</TD><TD>1</TD><TD>1</TD></TR><TR><TD>A</TD><TD>D</TD><TD>1</TD><TD>2</TD></TR><TR><TD>A</TD><TD>D</TD><TD>2</TD><TD>1</TD></TR><TR><TD>A</TD><TD>D</TD><TD>2</TD><TD>2</TD></TR></TBODY></TABLE></LI-SPOILER> Thu, 30 Nov 2023 23:03:39 GMT https://community.jmp.com/t5/Discussions/A-special-kind-of-Join-Tables/m-p/704483#M88865 hogi 2023-11-30T23:03:39Z Re: A special kind of Join Tables https://community.jmp.com/t5/Discussions/A-special-kind-of-Join-Tables/m-p/704560#M88871 <P>I am wondering whether these are errors:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="peng_liu_0-1701390830575.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/59175i33E5608970E8170B/image-size/medium?v=v2&amp;px=400" role="button" title="peng_liu_0-1701390830575.png" alt="peng_liu_0-1701390830575.png" /></span></P> <P>If they are "B"'s, sounds like you want a Cartesian join:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="peng_liu_1-1701391068500.png" style="width: 999px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/59176i0A45075B3255F409/image-size/large?v=v2&amp;px=999" role="button" title="peng_liu_1-1701391068500.png" alt="peng_liu_1-1701391068500.png" /></span></P> <P>&nbsp;</P> Fri, 01 Dec 2023 00:38:53 GMT https://community.jmp.com/t5/Discussions/A-special-kind-of-Join-Tables/m-p/704560#M88871 peng_liu 2023-12-01T00:38:53Z Re: A special kind of Join Tables https://community.jmp.com/t5/Discussions/A-special-kind-of-Join-Tables/m-p/704691#M88889 <BLOCKQUOTE><HR /><a href="https://community.jmp.com/t5/user/viewprofilepage/user-id/2781">@peng_liu</a>&nbsp;wrote:<BR /><P>I am wondering whether these are errors ...</P><HR /></BLOCKQUOTE><P>Hm ... this shows that you (no: I) should not do such things manually via copy paste :)</img><BR /><BR /></P><P>many, many tanks - I am so glad that I decides to ask - instead of starting programming.</P><P><BR />any chance that there exist as well a drop-down-1-click solution for this one:<BR /><LI-MESSAGE title="Graph builder Frame size JSL" uid="46012" url="https://community.jmp.com/t5/Discussions/Graph-builder-Frame-size-JSL/m-p/46012#U46012" discussion_style_icon_css="lia-mention-container-editor-message lia-img-icon-forum-thread lia-fa-icon lia-fa-forum lia-fa-thread lia-fa"></LI-MESSAGE>&nbsp;?</P> Fri, 01 Dec 2023 07:37:10 GMT https://community.jmp.com/t5/Discussions/A-special-kind-of-Join-Tables/m-p/704691#M88889 hogi 2023-12-01T07:37:10Z