cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
    Regular business hours will resume at 9:00 a.m. EST on Friday, Jan. 2, 2026.
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
AndresGlez
Level III

Create duplicate data in a table by column in a different table

Good day community,  I am wondering if there is a way to duplicate data in "Big class" table (40 rows) by column in a Table "Region" (6 rows), intention is to assign for each set of Big class table a new column from Region to create total of 240 rows. 

Attaching files for details.

Thank you!!!

1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

Re: Create duplicate data in a table by column in a different table

All you need to do is to do is a Cartesian Join

     Tables=>Join

and then select "Cartesian Join" from the Matching Specification

cartesian.PNG

Jim

View solution in original post

2 REPLIES 2
txnelson
Super User

Re: Create duplicate data in a table by column in a different table

All you need to do is to do is a Cartesian Join

     Tables=>Join

and then select "Cartesian Join" from the Matching Specification

cartesian.PNG

Jim
AndresGlez
Level III

Re: Create duplicate data in a table by column in a different table

Thank you @txnelson , I did not know this option, this fixed my problem,

Recommended Articles