A special kind of Join Tables

[#1]

Let's say, I have 2 tables. Table dt1 has an arbitrary number of columns (a, b , ...) and table dt2 has columns (x, y , ...).

What is the easiest way in Jmp to generate a crossed join of the two tables - such that for any row an, bn,  ... from dt1, there are rows in the final table with an, bn,  ...  in combination with values xm,ym, ... from dt2.

View more...

a	b
A	C
A	D
B	C
B	D

x	y
1	1
1	2
2	1
2	2

a	b	x	y
A	C	1	1
A	C	1	2
A	C	2	1
A	C	2	2
A	D	1	1
A	D	1	2
A	D	2	1
A	D	2	2
B	C	1	1
B	C	1	2
B	C	2	1
B	C	2	2
A	D	1	1
A	D	1	2
A	D	2	1
A	D	2	2

[#2 · Accepted solution]

I am wondering whether these are errors:

If they are "B"'s, sounds like you want a Cartesian join:

[#3]

---

@peng_liu wrote:

I am wondering whether these are errors ...

---

Hm ... this shows that you (no: I) should not do such things manually via copy paste :)

many, many tanks - I am so glad that I decides to ask - instead of starting programming.

any chance that there exist as well a drop-down-1-click solution for this one:
Graph builder Frame size JSL ?