cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
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,